SELECT C.TABSCHEMA,
C.TABNAME, C.COLNAME FROM SYSCAT.TABLES AS T,
SYSCAT.COLUMNS AS C WHERE
T.TBSPACEID = 8 AND T.TABLEID = 49 AND C.COLNO = 8 AND
C.TABSCHEMA = T.TABSCHEMA AND C.TABNAME = T.TABNAME
SELECT C.TABSCHEMA,
C.TABNAME, C.COLNAME FROM SYSCAT.TABLES AS T,
SYSCAT.COLUMNS AS C WHERE
T.TBSPACEID = 8 AND T.TABLEID = 49 AND C.COLNO = 8 AND
C.TABSCHEMA = T.TABSCHEMA AND C.TABNAME = T.TABNAME