Synonyms Wizard (DB2 Z/OS)
Go Up to IBM DB2 for z/OS Object Wizards
A synonym is an alternative name you can create for a table or view. Using a synonym can make it easier for you to remember that table or view instead of having to think about the possibly cumbersome formal name (for example, a show dog may have a formal name that incorporates all his ancestors, but will answer to the name Spot around the house).
To create a new synonym using a wizard:
- Open a creation wizard for a synonym. For details, see Opening an Object Wizard.
- Use the following topics as a guide to setting properties and performing tasks as you pass through the wizard panels:
- Properties panel - for details, see Synonyms (DB2 z/OS) - Properties.
- DDL View panel - for details, see Previewing the DDL Generated to Create the New Object.
- Finally, use the Execute button to create the object.
Synonyms (DB2 z/OS) - Properties
When creating or editing a synonym, this tab/panel lets you work with the following settings:
Setting | Description |
---|---|
Schema |
Select the schema that is to own the synonym. |
Name |
Provide a name for the synonym. |
Referenced Object Owner |
Select the owner of the object to which you are creating a synonym. |
Referenced Object Type |
Select the type of object (TABLE, VIEW) to which you are creating a synonym. |
Referenced Object Name |
Select the specific object to which you are creating a synonym. |