Is there a way to select the text description of a set of fields in a
table? I am looking for a result set like the following:
fieldName | fieldDesc
------------------------------------------
RMCUST Customer Number
RMADDR Customer Address
RMMZIP Customer Zip
I can currently use the COLUMNS table to grab the field names but not
the description.
ex:
SELECT COLUMN_NAME FROM qsys2.columns WHERE TABLE_NAME = 'CUSTMAST'
In MySQL you can just use 'DESC tablename'. That does not seem to work
in DB2.
Thanks!
-Nick |