Synonyms

In Db2, a synonym is an alternate name for a table or view. Synonyms are created by users who want to refer to tables by names that are easier to remember. These alternate names can also be used in applications to reference tables without tying the source code to the physical object.
carcudb2
In Db2, a synonym is an alternate name for a table or view. Synonyms are created by users who want to refer to tables by names that are easier to remember. These alternate names can also be used in applications to reference tables without tying the source code to the physical object.
You can use the synonym options to create, template, alter, and drop synonyms.
The Synonym option includes the following features.
  • Table Selection Help. Instead of entering a specific table name, selection criteria can be entered to receive a list of tables that meeting the criteria.
  • Create Synonyms for Multiple Users. Create synonyms for multiple users by listing the user's ID(s). SET CURRENT SQLID statements are generated for each user ID specified.