By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,004 Members | 1,222 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,004 IT Pros & Developers. It's quick & easy.

Selecting Field Description With DB2 and SQL

P: n/a
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

Aug 13 '07 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.