Use the Describe command eg: Describe table <tablename>

How to see the structure of db2 table??

Question Posted / prem

Answer Posted / prem

Use the Describe command

eg: Describe table <tablename>

Is This Answer Correct ?

38 Yes

47 No

Please Help Members By Posting Answers For Below Questions

List some fields from sqlca?

1107

What is collection in db2 bind?

1061

Define sqlca.

1172

Why do we bind in db2?

1273

What are db2 objects?

1089

Mention the different locking levels that are available in db2.

1184

Which are the db2 tools to protect integrity of the database?

1166

What is deadlock in db2?

1120

Differentiate between cs and rr isolation levels? Where do you specify them?

1118

What are catalog tables in db2?

1106

Which component is responsible for processing sql statements and selecting access paths?

1178

What is host variable in db2 cobol?

1135

What is dbrm? What it contains?

1216

B37 abend during spufi?

1511

What is a db2 cursor?

1108