Distinct Types panel
You use the Distinct Types panel to list the distinct types in the Db2® catalog.
Panel and field definitions
The columns that are displayed include the SEL field and columns of SYSIBM.SYSDATATYPES.
Process Options Utilities Help
──────────────────────────────────────────────────────────────────────────────
ZDT/Db2 (DFG2) Distinct Types
Location: Format TABL
+
SEL SCHEMA NAME OWNER CREATEDBY SOURCESCHEMA SOURCETYPE METATYEX
* * * * * * *
---- #1--+-- #3--+--- #2--+--- #4--+---- #5--+----1-- #6--+----- #18-+----1-
**** Top of data ****
SHRIKE2 DT1 SHRIKE2 SHRIKE2 SYSIBM CHAR Distinct Ty
SHRIKES CHAR80 SHRIKE2 SHRIKE2 SYSIBM CHAR Distinct Ty
**** End of data ****
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 |
|---|---|
| See Comment panels | Line command COM |
| Create Distinct Type panel | Line command CR |
| See Drop panels | Line command DR |
| Grant privileges panels | Line command G |
| Details panels | Line command I |
| Privileges panels | Line command P |
| Line command PS | |
| Revoke privileges panels | Line command R |
| Display Row panel | Line command ROW |
| Schemas panel | Line command SCH |
| Tables, Views and Aliases panel | Line command T |
| Sort Fields panel | Primary command SORT |