SYSCOLUMNS Query

SELECT *
FROM SYSIBM.SYSCOLUMNS
-- WHERE TBCREATOR = 'TABLECREATORNAME'
-- AND TBNAME = 'TABLENAME'
-- ORDER BY COLNO
;