How to know the primary key of a table without defining the
primary key in the table?

Answer Posted / kums

you could use SYSIBM.SYSINDEXES table to know more about
the table index.

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is iseries database?

597


Is db2 relational database?

574


What is the default page size of buffer pools?

652


What is explain plan in db2?

592


Explain about rct.

654






What is the max length of sqlca?

769


can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

1810


How many databases are there?

596


What is null indicator in cobol db2?

589


What is runstats and reorg in db2?

802


What is db2 bind process?

761


Where can you declare a cursor in a cobol-db2 program?

606


Is ibm db2 free?

579


What is multi row fetch in db2?

614


What is dbrm? What it contains? When it will be created?

595