Creating a synonym

To create a new synonym, perform the following on the Db2® Object Functions panel:

  1. Type 7 in the Object Type entry field.
  2. Type C on the command line.
  3. Press Enter. FM/Db2 displays the Create Synonym panel.

A synonym is an alternative name for a table or view. It is used as an unqualified identifier and is specific to the SQLID that owns the synonym.

For more details, see the Db2 UDB for z/OS SQL Reference.

Related references