The three data types are DATE, TIME and TIMESTAMP. CHAR can be used to specify the format of each type. The DAYS function calculates the number of days between two dates. (It's Y2K compliant).

burelamanohar

• Feb 6th, 2007

DATE PIC X(10)TIME PIC X(8)TIMESTAMP PIC X(26)

Answer Question  Select Best Answer

jitendraprajapati

• Jan 25th, 2007

Try this --All PK and Constraints Select * from SYSCAT.COLUMNS;--All references (FK)Select * from SYSCAT.REFERENCES;

Regards,
Jitendra

Answer Question  Select Best Answer

A multiple index is not one index but two indexes for two different columns of a table. A composite index is one index made up of combined values from two columns in a table. If two columns in a table will often be accessed together a composite index will be efficient.

saibabu

 Profile Answers by saibabu Questions by saibabu

• Jan 12th, 2007

If an index is  created  on more than  one column  ,which r frequently used in where clause of  select statement.  it will show the  effect in increace in performance .

Answer Question  Select Best Answer

They are the opposite of root pages. Leaf pages are the lowest level index pages - the pages that contain index entries and information to the corresponding table rows.

MB

• Jan 11th, 2007

Leaf pages are used in context of indexes and contain data.

Answer Question  Select Best Answer

SHANKAR

• Dec 31st, 2006

BY USING HANDLE AID.

kaushikee

 Profile Answers by kaushikee Questions by kaushikee

• Jun 7th, 2006

Hi,   I am little confused, to find this ques. in DB2 section. If it is for CICS the ans. is as follows:   The Execution Interface Block(EIB) has a field called EIBAID which contai...

Answer Question  Select Best Answer

Denormalizing DB2 tables reduces the need for processing intensive relational joins and reduces the number of foreign keys.

senthil k

• Dec 26th, 2006

In datawarehouse environment, mostly all the tables are semi- normalized ( ie it is fully normalized) to reduce no of joins . so de-normalization is having lot of advantages in datawarehouse .

Answer Question  Select Best Answer

The three types are shared, update and exclusive. Shared locks allow two or more programs to read simultaneously but not change the locked space. An exclusive lock bars all other users from accessing the space. An update lock is less restrictive; it allows other transactions to read or acquire shared locks on the space.

ajay ajjur

• Dec 19th, 2006

3 types of locks are SHARE EXCLUSIVE UPDATE

Answer Question  Select Best Answer

It is a data structure that must be included in any host-language program using SQL. It is used to pass feedback about the sql operations to the program. Fields are return codes, error messages, handling codes and warnings.

ajay ajjur

• Dec 19th, 2006

SQLCA is t communication area wher v can check t return codes, no of updated , deleted records it contains SQLCODE, SQLERRD, SQLERRM etc.....

Answer Question  Select Best Answer

pinaki

• Dec 7th, 2006

a package/dbrm is binded to a plan after compilation of a cobol-db2 / cics-cobol-db2 program.a dbrm is produced during precompile step.usually dbrm is associated to a package and package is binde...

umapathi

• Sep 6th, 2006

plan - it can contain packages and dbrms. package- it contains only dbrms. it is advantageous and cost effective.

Answer Question  Select Best Answer

arivu

• Dec 1st, 2006

How does you get record no from 5 to 15 from a dataset of 100 records?        

SreeHari

 Profile Answers by SreeHari Questions by SreeHari

• Nov 15th, 2005

Hi,From File-Aid Main  Menu Choose option Browse or Edit and press enterWhere we suppose give physical file name and copybook name and copy book path and also At the bottom there is option '...

Answer Question  Select Best Answer

sangramkc

• Nov 28th, 2006

for both -911 or -913 , you can check further SQLERRD(3) also contains the reason-code which indicates whether a  deadlock or timeout occurred. The most common reason codes are:   ...

bnirmalraj

• Sep 26th, 2006

911 - THE CURRENT UNIT OF WORK HAS BEEN ROLLED BACK DUE TO      DEADLOCK OR TIMEOUT. REASON reason-code, TYPE OF RESOURCE resource-type, AND RESOURCE NAME resource-name &...

Answer Question  Select Best Answer

Prasad

• Nov 22nd, 2006

Hi,Both the above ways can be selected.If u want to load the table with some data u can use load utility.If u want to move some value in the prog then u can go for the host variables. 

javid

• Mar 21st, 2006

By utilising Load Utility.

Answer Question  Select Best Answer

A view is a virtual table made up of data from base tables and other views, but not stored separately.

chandra kanth ganga

• Nov 10th, 2006

View is a vitual table, which do not have physical storage.we can create a view from one or more than one table(s) or view(s).if any modification is done on the base table the view is also get effected.but they are some limitations while creating views while using joins.

vijay saxena

• Oct 24th, 2006

A view table is virtual or logical table which depends on base table by using this the filtered records may be accessed frequently.

Answer Question  Select Best Answer

Sandeep

• Oct 16th, 2006

 Hi,   BMC S/w has provided this facility to us,   Rather than i explain it will be better u refer   http://documents.bmc.com/products/documents/02/43/60243/60243.pdf thnx, Sandeep

Answer Question  Select Best Answer

Referential integrity refers to the consistency that must be maintained between primary and foreign keys, ie every foreign key value must have a corresponding primary key value.

Tapastapu

 Profile Answers by Tapastapu Questions by Tapastapu

• Aug 11th, 2006

The relation of the primary key of  a base table with foreign key of the reference table is known as referential integriety.

Answer Question  Select Best Answer

Tapastapu

 Profile Answers by Tapastapu Questions by Tapastapu

• Aug 11th, 2006

hi everybody,i am new member of this group.what r the compiler options we use?the compiler options are:for COBOL: IGYCRCTLfor COBOL-DB2: IKJEFT01where the compiler option will be?IGYCRCTL: this is use...

Answer Question  Select Best Answer

umapathi

• Jul 21st, 2006

hi the above said answer is correct  but selection criteria to usage should be T

pradipta

• Sep 9th, 2005

Go to file-aid copy option.Enter the from dataset to be copied and to dataset to which you want to copy.go to options. Enter 0 at Initial records to skip field.Then enter 3 at the no of records to skip field and 1 to no of records to select.press enter and PF3.

Answer Question  Select Best Answer

srini1

 Profile Answers by srini1 Questions by srini1

• Jul 3rd, 2006

You should use cobol defined variable RETURN-CODE in you cobol program

srini

• Jul 3rd, 2006

Hi,you should move the value to cobol defined variable RETURN-CODE

Answer Question  Select Best Answer

The explain statement provides information about the optimizer's choice of access path of the sql.

Prasanth

• Jun 28th, 2006

The EXPLAIN statement obtains information about access path selection for an explainable statement. A statement is explainable if it is a SELECT or INSERT statement, or the searched form of an UPDATE ...

Answer Question  Select Best Answer

Navaneetha krishnan

• Jun 21st, 2006

Do u want the the list of error codes in Cobol or jcl or Vsam of Db2 or cics?

Answer Question  Select Best Answer