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:
- The system option, Show all catalog table columns, affects which columns FM/Db2 displays when you use the Object List utility.
- 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 |