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

What is the physical storage length of date data type?

1305

Mention the downsides of page level lock.

1214

Explain what are the various isolation levels possible?

1097

Explain dclgen.

1270

How does db2 sample database connect?

1082

What is the difference between cursor and select statement?

1152

What are db2 objects?

1089

What is the difference between nvl and coalesce?

1107

Mention the various locks that are available in db2.

1085

When reorg is used?

1182

How do I start db2 in windows?

1139

What is the syntax for FETCH in DB2 ?

1267

Mention some fields that are a part of sqlca.

1096

How do I create a view in db2?

1074

What is the maximum size of a char data type in db2?

1051