Description of columns in a DB2 table

Question

Hi,

How can we know the description of every column in a table(DB2) through SQL?

My data base is DB2.

Thanks in Advance

Answer 1

See if this is of any help.

Answer 2

select 
  tabname,
  colname,
  typename,
  length,
  scale,
  default,
  nulls,
  identity,
  genereted,
  remark,
  keyseq 
from 
  syscat.columns

Answer 3

describe table schema.table_name

DB2 Describe Command

Answer 4

I work on an iSeries DB2 box (v5r4), it is a special flavor of DB2.

If you're on or connecting to an iSeries (AS/400), the link mentioned by Anton is most excellent (sorry, can't vote yet!)

Describe does not work on an iSeries, but will work with DB2 on the other platforms.