Which DB2 catalog tables are used to produce a list of table column by table f

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

Question Posted / guest

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

SYSIBM.SYSCOLUMNS

Is This Answer Correct ?

6 Yes

3 No

More DB2 Interview Questions

How do you retrieve the first 5 characters of firstname column of db2 table emp?

How can we read records for specific member in CL? AND rpg?

What is a NULL value? What are the pros and cons of using NULLS?

If we have 100 records in the PF, we deleted all the records then what is the Size of the PF?

Why do we bind in db2?

What is table space in db2?

What is -904 sql code? How to resolve it?

How would you print the output of an SQL statement from SPUFI?

Explain the use of the WHERE clause?

What is a db2 schema?

What are foreign keys in db2?

when does the SQL statement gets executed when you use cursor in the application programming ?

For more DB2 Interview Questions Click Here