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.



In MySQL you can just use 'DESC tablename'. That does not seem to work
in DB2.



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.