SELECT COLNAME,
COLNO,
TYPENAME,
LENGTH,
SCALE,
NULLS
FROM SYSCAT.COLUMNS
WHERE TABSCHEMA = 'FCTMDT9' AND TABNAME = 'CTMTCAR'
EXCEPT
SELECT COLNAME,
COLNO,
TYPENAME,
LENGTH,
SCALE,
NULLS
FROM SYSCAT.COLUMNS
WHERE TABSCHEMA = 'FCTMDT9' AND TABNAME = 'CTMTQCR'
WITH UR;
SELECT COLNAME,
COLNO,
TYPENAME,
LENGTH,
SCALE,
NULLS
FROM SYSCAT.COLUMNS
WHERE TABSCHEMA = 'FCTMDT9' AND TABNAME = 'CTMTQCR'
EXCEPT
SELECT COLNAME,
COLNO,
TYPENAME,
LENGTH,
SCALE,
NULLS
FROM SYSCAT.COLUMNS
WHERE TABSCHEMA = 'FCTMDT9' AND TABNAME = 'CTMTCAR'
WITH UR;
这里没有考虑到default值,generated columns等因素,在实际应用中应该考虑到。