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 copy pending status in db2?
List down the data types in the db2 database.
What is dbrm library?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
What is cursor with hold option in db2?
Is db2 relational database?
What is bufferpool in db2?
What is lock escalation in db2?
Comment whether the cursor is closed during commit or not.
What is the difference between db2 and oracle?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
Name the various locking levels available?
What is dbrm? What it contains?
How to resolve deadlock issue
What is the function of logging in the db2 database?