SELECT colName,TypeName FROM SYSCAT.COLUMNS WHERE TABSCHEMA = <database&

How to see the structure of db2 table??

Question Posted / kc

Answer Posted / kc

SELECT colName,TypeName FROM SYSCAT.COLUMNS WHERE TABSCHEMA = <database> AND TABNAME =<tablename>

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is a db2 package?

1065

Is the primary key a clustered index?

1150

What is reorg?

1164

What is dclgen in db2?

1151

In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

1110

How do I add a column to an existing table in db2?

1032

Where can you declare a cursor in a cobol-db2 program?

1078

What is multi row fetch in db2?

1053

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1109

What is bind package and plan in db2?

1056

What is package in cobol db2?

1120

Explain what are the various isolation levels possible?

1045

What is the maximum number of columns in a db2 table?

1286

What is a storage group (stogroup)?

1248

Explain the function of data manager.

1050