Which DB2 catalog tables are used to produce a list of
table column by table for all tables in a database?
Answer Posted / s
SYSIBM.SYSCOLUMNS
| Is This Answer Correct ? | 6 Yes | 3 No |
Post New Answer View All Answers
Outputs of explain are with matchcols = 0. What does this signify?
How to access db2 tables in mainframe?
How to view db2 table structure?
How do you select a row using indexes in db2?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
How to create backup table in db2?
What is the purpose of rollback and commit?
List down the types of triggers in the db2 database?
What is the difference between bind and rebind in db2?
What is load utility in db2?
What is db2 command?
What is db2 and what is the use of db2 optimizer?
Is ibm db2 open source?
What is rct?
Define check constraint.