What is equivalant of desc table command of oracle in DB2?

assuming that in oracle desc stands for describe

C:\Program Files\IBM\SQLLIB\BIN>db2 describe table eone.tdb_patch_dtl

Column Type Type
name schema name Length Scale Nulls
------------------------------ --------- ------------------ -------- ----- -----
TITLE SYSIBM VARCHAR 100 0 No
ACTION SYSIBM CHARACTER 1 0 No
APPLIEDON SYSIBM TIMESTAMP 10 0 No
REMARK SYSIBM VARCHAR 100 0 Yes

4 record(s) selected.


C:\Program Files\IBM\SQLLIB\BIN>db2 describe select * from eone.tdb_patch_dtl

SQLDA Information

sqldaid : SQLDA sqldabc: 896 sqln: 20 sqld: 4

Column Information

sqltype sqllen sqlname.data sqlname.length
-------------------- ------ ------------------------------ --------------
448 VARCHAR 100 TITLE 5
452 CHARACTER 1 ACTION 6
392 TIMESTAMP 26 APPLIEDON 9
449 VARCHAR 100 REMARK 6

Rahul Singh