Tables, Views and Aliases panel
You use the Tables, Views and Aliases panel to list table, view, and alias object types in the Db2® catalog.
Panel and field definitions
The columns that are displayed include the SEL field and columns of SYSIBM.SYSTABLES.
Process Options Utilities Help
──────────────────────────────────────────────────────────────────────────────
FM/Db2 (DFG2) Tables, Views and Aliases 44 of 1000
Location: Format TABL
TABLE TABLE DATABASE OBJECT +
SEL OWNER NAME NAME TYPE +
* * * *
---- #2--+----1----+- #1--+----1----+----2----+----- #4--+--- #61-+----1----
DMYAPP TABLES DSNDB06 View
DMYAPP TABLESPACE DSNDB06 View
DMYAPP VIEWS DSNDB06 View
DSB81010 EMP_COPY DSN00245 Table
DSN81010 ACT DSN8D10A Table
DSN81010 CATALOG DSN8D10X Table
DSN81010 CUSTOMER DSN8D10X Table
DSN81010 DEPT DSN8D10A Table
DSN81010 EACT DSN8D10A Table
DSN81010 EDEPT DSN8D10A Table
DSN81010 EEMP DSN8D10A Table
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
This panel appears when you specify the T line command against an object displayed in a list of Db2® objects.