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

Answer Posted / ambika

u can use sysibm.syskeys to view the primary key of a
particular table provided if u have declared any attribute
as NOT NULL. if there are multiple columns of such kind u
the above procedure wont help.

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?

2293


How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

1981


Explain packages.

871


What is a page in db2?

800


Describe major components of db2?

860


What do you mean by commit and rollback?

775


What is the syntax for FETCH in DB2 ?

924


How do I create a view in db2?

794


What is sqlca’s maximum length?

901


When reorg is used?

866


How do you pull up a query which was previously saved in qmf?

904


Can we update view in db2?

773


What is load utility in db2?

896


What is innodb buffer pool?

760


How can you find out the # of rows updated after an update statement?

863