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

How to see the structure of db2 table??

Question Posted / kc

4 Answers
32881 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / kc

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

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the difference between oracle and db2?

1031

How does coalesce work?

959

Mention the definition of cobol in varchar field.

1179

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

964

What is db2 stogroup?

1095

Explain the function of data manager.

991

Is db2 a mainframe?

969

What is check constraint in db2?

1012

How do we specify index to include or not during bind process.

2070

How many databases are there?

990

How will you return the number of records in table?

880

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 ?

2278

What is the difference between db2 and oracle?

1068

What does runstats do in db2?

1023

What is a bind in db2?

983