Forum

vielleicht sowas:

SE LECT * FROM
( SE LECT * FROM SYSIBM.SYSCOLUMNS
WHERE TBNAME = ‚tabelle1‘
AND TBCREATOR = ‚creator1‘
) A
FULL OUTER JOIN
( SE LECT * FROM SYSIBM.SYSCOLUMNS
WHERE TBNAME = ‚tabelle2‘
AND TBCREATOR = ‚creator2‘
) B

ON A.NAME = B.NAME
AND A.COLTYPE = B.COLTYPE
AND A.LENGTH = B.LENGTH
AND …

WHERE A.NAME IS NULL OR B.NAME IS NULL