sita

• Feb 26th, 2007

Yes, We can see the Comp-3 Data by pressing Hex On In the File-AID

Bibhu

• Mar 31st, 2006

What I think we cannot see the comp-3 value by USAGE verbwe have to type HEX ON in the command prompt of that particular file to see the numberExample:        &...

Answer Question  Select Best Answer

rupesh

• Feb 22nd, 2007

Select constrint_name,constraint_type,search_condition from user_constraintswhere table_name='name of table in upper case';

hemant

• Apr 18th, 2006

SELECT * FROM SYSIBM.SYSCOLUMNS WHERETBNAME=table-name AND TBCREATOR=' creator-name';orto see column names, types and lengthsSELECT NAME,COLTYPE,LENGTH FROM SYSIBM.SYSCOLUMNS WHERE TBNAME=table-name AND TBCREATOR=' creator-name';  the above queries can be used 

Answer Question  Select Best Answer

For a clustered index DB2 maintains rows in the same sequence as the columns in the index for as long as there is free space. DB2 can then process that table in that order efficiently.

burelamanohar

 Profile Answers by burelamanohar Questions by burelamanohar

• Feb 7th, 2007

Clustered index is unique for any given table and we can have only one clustered index on a table. The leaf level of a clustered index is the actual data and the data is resorted in case of clustered index

Amol

• Sep 2nd, 2006

Partitioned table is clustered by clustering index

Answer Question  Select Best Answer

The FREE command can be used to delete plans and/or packages no longer needed.

burelamanohar

• Feb 6th, 2007

PCTFREE : It allows for insertion of new records and for expansion of variable length fields.

FREEPAGE : The number of pages to be loaded between each page left free. It is useful for finding a near page for inserting a new record.

JAVID

• Mar 27th, 2006

Free Command is meant for the deletion of plans. A single free command can delete max. of 12 packages.welcome for feed back

Answer Question  Select Best Answer

A thread is the connection between DB2 and some other subsystem, such as CICS or IMS/DC.

burelamanohar

• Feb 6th, 2007

A thread is a control structure used by DB2 to communicate with an application programme. Every programme must communicate with DB2 by means of Thread.

Answer Question  Select Best Answer

This is a key concept for any relational database. Isolation level is the manner in which locks are applied and released during a transaction. For DB@ a 'repeatable read' holds all locks untile the transaction completes or a syncpoint is issued. For transactions using 'cursor stability' the page lock releases are issued as the cursor 'moves', i.e. as the transaction releases addressability to the...

burelamanohar

• Feb 6th, 2007

Isolation level means the extent to which the transaction isolates the data is accessed

Answer Question  Select Best Answer

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