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 coalesce in db2?
Is db2 a database?
Mention data types used in db2 ?
What is the purpose of rollback and commit?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
Give the name of some fields form sqlca.
What do you mean by rollback?
What is iseries database?
How can you find out the # of rows updated after an update statement?
What are the different types of base tables?
What is the use of predicate?
How does coalesce work?
What is ibm db2 database?
Explain about open switch business continuity software?
What type of database is db2?