Where could you look if you had a question about whether a
column has been defined as an index?
Answer Posted / sadiq afroze
This information can be found in SYSIBM.SYSINDEXES
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
List down the data types in the db2 database.
What is package in db2 mainframe?
List out the buffer pools in db2
Explain in brief how does db2 determine what lock-size to use?
What is db2 look?
What is a page in db2?
Mention the different locking levels that are available in db2.
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 .....
What is a trigger in the db2 database?
B37 abend during spufi?
What os does db2 run on?
Discuss about db2 bind?
What are packages in db2?
Explain the benefits you can get from mainframe connect?
Is db2 free?