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 the difference between using bind () and rebind () methods of naming class?

1457

What is the result of open cursor statement?

1127

What is concurrency?

1304

Mention the definition of cobol in varchar field.

1315

Discuss about db2 bind?

1154

How many databases can be created inside an instance in db2 ?

1087

Can there be more than one cursor open for any program?

1225

What are union and union all?

1036

What is cursor with hold option in db2?

1136

How do I connect my db2 database to ibm?

1085

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

757

How do I delete a column in db2?

1154

Is db2 a database?

1027

What is a db2 schema?

1296

When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3632