Which DB2 catalog tables are used to produce a list of
table column by table for all tables in a database?



Which DB2 catalog tables are used to produce a list of table column by table for all tables in a d..

Answer / s

SYSIBM.SYSCOLUMNS

Is This Answer Correct ?    6 Yes 3 No

Post New Answer

More DB2 Interview Questions

What else is there in the PLAN apart from the access path?

1 Answers  


what is the soft code for deadlock ?

2 Answers   Logica CMG,


What is multi row fetch in db2?

0 Answers  


What is the connection string to connect to the DB2 Database ?

0 Answers   MCN Solutions,


i have a table like this : Name ADDRESS Toto 123 ... Toto 456 ToTo 678 I would like to delete 2 last row...please tell me how to delete its

5 Answers   EDS,






what needs to be done if a table is in copy pending / check pending status?

5 Answers   Xansa,


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 ?

0 Answers   JPMorgan Chase,


Give some example of statistics collected during RUNSTATS?

1 Answers  


What are the various locking levels available?

3 Answers  


Define declaration generator (dclgen).

0 Answers  


What is the difference between Where and Having Clause

7 Answers   IBM, iFlex,


How do you do the EXPLAIN of a dynamic SQL statement?

2 Answers  


Categories