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
What is the result of open cursor statement?
What is lock escalation in db2?
What is a page in db2?
What is meant by union and union all?
What is db2 bind?
How is a typical db2 batch pgm executed?
List out the three types of page locks that can be held.
Mention the downsides of page level lock.
What does db2 stand for?
What is db2?
Outputs of explain are with matchcols = 0. What does this signify?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
What is check constraint. Explain with example.
What is dbrm in db2 database?
Which command is used to remove all rows from a table?