SYSIBM.SYSCOLUMNS

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

Question Posted / s

Answer Posted / s

SYSIBM.SYSCOLUMNS

Is This Answer Correct ?

6 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Is db2 a programming language?

1048

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2852

What is the max length of sqlca?

1216

What type of database is db2?

971

How to create db2 table in mainframe?

1154

Which command is used to remove all rows from a table?

1109

What is the use of with ur in db2?

1056

What is the difference between spufi and qmf?

1130

What is load utility in db2?

1181

What is explain plan in db2?

995

What is the difference between drop table and delete table?

1207

Define data page.

1067

What is a collection in db2?

1034

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2938

Is it possible to create an Instance in DB2 using DB2 Control Center ?

1104