Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2008
    Location
    India
    Posts
    40

    Unanswered: To check the column attributes or field type

    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?

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    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.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Feb 2008
    Location
    Japan
    Posts
    3,483
    You can use DESCRIBE command in QMF.

    See DESCRIBE command on "DB2 QMF Reference".
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •