How to view db2 table structure?
Answer / Madhulika Kumari
You can use the DESCRIBE or DESC command in DB2 to view the structure of a table, including column names, data types, and lengths. For example: `DESCRIBE your_table_name`.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is db2 catalog database?
Mention data types used in db2 ?
What is an instance in db2?
Mention and explain the contention situations caused by locks?
What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run?
What is cursor?
Is schema the same as database?
how to resolve -811 error. give clear explination
how to execute qcmdexc in rpgle?plz write code also?
What is lock contention?
Explain about mirror activator disk mirroring?
What happens to the PLAN if index used by it is dropped?