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
──────────────────────────────────────────────────────────────────────────────
FM/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 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 |
---|---|
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 |
Generate SQL From Db2 Catalog panel | Line command GEN |
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 |