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

Related tasks

Related references