How to describe a table in DB2.

The below query will describe the table.

select distinct(name), coltype, length from sysibm.syscolumns where tbname = '<table_name>' for read only with ur