How to view DB2 Table structure

Question

How to view the table structure in DB2 database

Answer 1

I got the answer from the sysibm.syscolumns

Select distinct(name), ColType, Length from Sysibm.syscolumns where tbname = 'employee';