prem

• Sep 20th, 2005

By create single plan and two packages.

Answer Question  Select Best Answer

Nick

• Nov 30th, 2005

The Checkpening is referential integrity is in doubt or its check constraints are violated. To remove need to run CHECK data utility.Copy pending - LOAD places a table space in the copy pending status. to remove need to take the backup on a table space

Answer Question  Select Best Answer

manoj pingale

• Dec 8th, 2005

The indexset and the sequence set are the two sets of records in the index component of the vsam KSDS the other being the data component. The sequence set contains pointers to each CI within the&...

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

siva kumar

• Nov 24th, 2005

We can abend the program based on certain conditons.If the condition is satisfied call the program 'ILBOABN0' using abned code.CALL 'ILBOABN0' USING U0165.

Answer Question  Select Best Answer

Prashtal

 Profile Answers by Prashtal Questions by Prashtal

• Jan 3rd, 2006

Hi,         Whenever a component is retrieved from the production base to a package, the component automatically gets compiled and staged. If not, then you can ...

Answer Question  Select Best Answer

Saradha

• Oct 14th, 2005

Commonly, 1 byte of space is assigned to each digit/char.But if declared as 'Packed Decimal' (also known as COMP-3), then 2 digit occupy only 1 byte.i.e if X = 78, then only 1 byte is assigned to X, rather than 2 bytes space.

Answer Question  Select Best Answer

Culver_lake

 Profile Answers by Culver_lake Questions by Culver_lake

• Mar 19th, 2006

I think what you mean is the DB2 catalog. Since the catalog database (DSNDB06) is a relational database made up of tables you "handle" it with SQL.

Answer Question  Select Best Answer

Kishore

• Jun 11th, 2006

If it is the number of DASDs you want to know, then it is 133 DASDs.

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

Raghuram Balakrishnan

 Profile Answers by Raghuram Balakrishnan Questions by Raghuram Balakrishnan

• Jul 19th, 2007

DB2 supports index with the help of leaf pages, non-leaf pages, and root pages.Leaf pages - Contains indexed values followed by Record Identifiers (RIDs).Non-leaf pages- Contains the upper range val...

Answer Question  Select Best Answer

A Cartesian product results from a faulty query. It is a row in the results for every combination in the join tables.

The LIKE keyword allows for string searches. The % sign is used as a wildcard.

SUBSTR is used for string manipulation with column name, first position and string length used as arguments. Eg. SUBSTR (NAME, 1 3) refers to the first three characters in the column NAME.

The simplest DB2 index is the B-tree and the B-tree's top page is called the root page. The root page entries represent the upper range limits of the index and are referenced first in a search.

Primary key and foreign key columns; columns that have unique values; columns that have aggregates computed frequently and columns used to test the existence of a value.