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

Related tasks

Related references