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
──────────────────────────────────────────────────────────────────────────────
ZDT/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 ZDT/Db2 displays when you use the Object List utility.
- You can also customize which columns ZDT/Db2 displays when you use the Object List utility. For details, see the Z Data Tools 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 |