To check the column attributes or field type

Neena John · #1 (**permalink**) 03-21-09, 01:55

Hi,
How to check the column attributes of the tables?I dont know the pds or library in which the table structure is defined.
Is there any way to check the column attributes(field type)throough QMF?

Marcus_A · #2 (**permalink**) 03-21-09, 04:19

On DB2 z/OS that information can be obtained in the sysibm.syscolumns table. You could write a query something like this:

select SUBSTR(NAME, 1, 35), COLTYPE, LENGTH, SCALE, NULLS from SYSIBM.SYSCOLUMNS WHERE TBCREATOR = 'XXX' and TBNAME = 'XXXXXX' ORDER BY COLNO;

This and other catalog tables are described in the SQL Reference manual Appendix F.

tonkuma · #3 (**permalink**) 03-21-09, 04:35

You can use DESCRIBE command in QMF.

See DESCRIBE command on "DB2 QMF Reference".

Quote:

DESCRIBE

X Use the DESCRIBE command to display information about a QMF object or a column in a table. The Describe function key can be used from a database object list panel or a Prompted Query panel.

Note: Using DESCRIBE on a database object list panel displays detail information about a single object. The amount of information shown is based on the type of object. On a Prompted Query panel, DESCRIBE displays a Column Description panel that shows information about the columns listed.

Internet Services

Web Development

Digital Marketing

Consumer Tech