467,209 Members | 1,352 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,209 developers. It's quick & easy.

Selecting Field Description With DB2 and SQL

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
  • viewed: 2050
Share:

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

7 posts views Thread by John | last post: by
6 posts views Thread by aaj | last post: by
2 posts views Thread by Patrick.O.Ige | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.