Synonyms panel

You use the Synonyms panel to list synonyms in the Db2® catalog.

Panel and field definitions

The columns that are displayed include the SEL field and columns of SYSIBM.SYSSYNONYMS.

  Process   Options   Utilities   Help
 ──────────────────────────────────────────────────────────────────────────────
 FM/Db2 (DFG2)                       Synonyms
 Location:                                                          Format TABL


 SEL    CREATOR  NAME               TBCREATOR    TBNAME             CREATEDBY
        *        *                  *            *                  *        
 ----   #2--+--- #1--+----1----+--- #4--+----1-- #3--+----1----+--- #6--+----
 ****  Top of data  ****
        CJUNELL  ACT                DSN8810      ACT                CJUNELL
        CJUNELL  DEPT               DSN8810      DEPT               CJUNELL
        CJUNELL  EMP                DSN8810      EMP                CJUNELL
        CJUNELL  EMPPROJACT         DSN8810      EMPPROJACT         CJUNELL
        CJUNELL  PROJ               DSN8810      PROJ               CJUNELL
        CJUNELL  PROJACT            DSN8810      PROJACT            CJUNELL
        CJUNELL  TCONA              DSN8810      TCONA              CJUNELL
        CJUNELL  TDSPTXT            DSN8810      TDSPTXT            CJUNELL
        CJUNELL  TOPTVAL            DSN8810      TOPTVAL            CJUNELL
        CJUNELL  VACT               DSN8810      VACT               CJUNELL
        CJUNELL  VASTRDE1           DSN8810      VASTRDE1           CJUNELL
 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
Create Synonym panel Line command CR
Create Alias panel Line command CRA
See Drop panels Line command DR
Details panels Line command I
Display Row panel Line command ROW
Tables, Views and Aliases panel Line command T
Sort Fields panel Primary command SORT

Related tasks

Related references