[code]
SELECT
TABNAME,COLNAME
FROM
SYSCAT.COLUMNS
WHERE TABNAME=
(SELECT
TABNAME
FROM
SYSCAT.TABLES
WHERE TBSPACEID=5 AND TABLEID=260)
AND COLNO=3;
[/code]
SELECT
TABNAME,COLNAME
FROM
SYSCAT.COLUMNS
WHERE TABNAME=
(SELECT
TABNAME
FROM
SYSCAT.TABLES
WHERE TBSPACEID=5 AND TABLEID=260)
AND COLNO=3;
[/code]