Wednesday, August 12, 2009

DB2-AS/400 SQL - Selecting Column Details

SELECT COLUMN_NAME, COLUMN_TEXT FROM QSYS2.SYSCOLUMNS WHERE TABLE_SCHEMA = '<LIBRARY>' AND TABLE_NAME = '<TABLE>'

No comments: