Mysql 提取 IBM DB2 表的字段及其描述 Column descriptions:
IBM DB2 Iseries Field Names and Field Descriptions
# Column descriptions:
Select SYSTEM_TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, varchar(COLUMN_TEXT, 50) As COLUMN_DESC
From QSYS2.SYSCOLUMNS
Where SYSTEM_TABLE_SCHEMA = 'DISTLIBW' # 需要查找的Table
# Table descriptions:
Select SYSTEM_TABLE_SCHEMA, TABLE_NAME, varchar(TABLE_TEXT, 50) As TABLE_DESC From QSYS2.SYSTABLES
Where SYSTEM_TABLE_SCHEMA = 'DISTLIBW' # 需要查找的Table