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
What is the advantage in De-normalizing tables in DB2?
what is diffrence b/w file-aid tool and file-aid utility???
Define db2.
What is a db2 cursor?
How to find the number of rows in a db2 table?
What is scrollable cursor in db2?
How do I connect my db2 database to ibm?
How do you concatenate the firstname and lastname from emp table to give a complete name?
What is the latest version of ibm db2?
What is explain in db2?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What is a system catalog table in db2?
is it compulsory commitment control in journal?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
can we view the access paths created by dbrm ? how ? thx