TABLE_TEXTとCOLUMN_TEXTを取得する方法(by DB2/400 )

LABLE ON にて日本語項目名が設定されている場合に有効。

// 日本語項目名取得
SELECT
A.TABLE_TEXT
, B.COLUMN_TEXT
FROM
QSYS2.SYSTABLES AS A
INNER JOIN QSYS2.SYSCOLUMNS AS B
ON A.TABLE_SCHEMA = B.TABLE_SCHEMA
AND A.TABLE_NAME = B.TABLE_NAME
WHERE
(
A.TABLE_SCHEMA = ‘XXXXXX’
OR A.TABLE_SCHEMA = ‘XXXXXX’
)
AND A.TABLE_NAME = ‘XXXXX’ FETCH FIRST 100 ROWS ONLY