Columns panel

You use the Columns panel to list column object types in the Db2® catalog.

Panel and field definitions

The columns that are displayed include the SEL field and columns of SYSIBM.SYSCOLUMNS.

  Process   Options   Utilities   Help
 ──────────────────────────────────────────────────────────────────────────────
 FM/Db2 (DFG2)                       Columns
                                                                    Format TABL


 SEL    NAME               TBCREATOR TBNAME              COLNO COLTYPE  LENGTH
        *                  *         *                       * *             *
 ----   #1--+----1----+--- #3--+---- #2--+----1----+--- ----#4 #5--+--- ----#6
 ****  Top of data  ****
        MAJSYS             CARLAND   PMR91932                1 CHAR          1
        ACTION             CARLAND   PMR91932                2 CHAR          1
        OBJFLD             CARLAND   PMR91932                3 CHAR          2
        SRCHCRIT           CARLAND   PMR91932                4 CHAR          2
        SCRTYPE            CARLAND   PMR91932                5 CHAR          1
        HEADTXT            CARLAND   PMR91932                6 CHAR         50
        SELTXT             CARLAND   PMR91932                7 CHAR         50
        INFOTXT            CARLAND   PMR91932                8 CHAR         79
        HELPTXT            CARLAND   PMR91932                9 CHAR         79
        PFKTXT1            CARLAND   PMR91932               10 CHAR         79
        PFKTXT2            CARLAND   PMR91932               11 CHAR         79
 Command ===>                                                       Scroll PAGE
  F1=Help      F2=Zoom      F3=Exit      F4=CRetriev  F5=RFind     F6=RChange
  F7=Up        F8=Down      F9=Swap     F10=Left     F11=Right    F12=Cancel
Note:
  1. The system option, Show all catalog table columns, affects which columns FM/Db2 displays when you use the Object List utility.
  2. You can also customize which columns FM/Db2 displays when you use the Object List utility. For details, see the File Manager Customization Guide.

To view other columns on this panel, press the Right function key (F11).

For a complete list of columns, refer to Db2® catalog tables in the DB2 for z/OS SQL Reference relevant to your version of Db2®.

SEL
Line command area.
For a list of the line commands you can use on this panel, see Object list line commands.

Parent panels

Child panels

To display this panel… Use/do this
Tables, Views and Aliases panel Line command AT
See Comment panels Line command COM
Column Distribution panel Line command DI
Distinct Types panel Line command DT
Grant privileges panels Line command G
Columns panel Line command H
Details panels Line command I
Label Column panel Line command LAB
Privileges panels Line command P
Display Row panel Line command ROW
Tables, Views and Aliases panel Line command T
Indexes panel Line command X
Sort Fields panel Line command SORT

Related tasks

Related references