Creating and Editing Aliases
Go Up to Creating and Editing Database Dependent Objects
An alias is an alternate name for a synonym (IBM Db2 for OS/390 or z/OS platforms only), table, view or other undetermined object type. An alias can provide a more meaningful object name for the target audience and can act as a low-overhead view. Table aliases can refer to each other in a process called chaining. Aliases let you assign the permissions of a database user to an object without creating a separate user entity or masking a user's identity.
The following database platforms support aliases:
- IBM DB2 for LUW 5.x+
- IBM DB2 for OS/390 5.x+
- IBM DB2 for z/OS 7.x+
Note: The DB2 Alias Wizard and DB2 Alias Editor share the same options, except for the Attachment Bindings options which are present only in the editor.
To create an alias
- In the Data Model Explorer, expand the Physical Main Model, right-click the Aliases node, and then select New Alias.
- Complete the DB2 Alias wizard, and then click Finish to create the alias.
- Once you create the alias, you can edit it by right-clicking the alias you want to change, and then selecting Edit Alias.
Name page/tab
Enter the name of alias and its owner.
- The alias name is the fully-qualified name of the alias and must not be the same as any table, view, alias, or synonym on the current server.
- The owner name is the user ID for the owner of the alias. This name is the authorization ID that qualifies the alias.
Reference page/tab
Select the type of object you want to reference. If there are any objects in the model that match your selection, you can click the identifier list to choose the appropriate identifier.
Definition page/tab
Enter or edit a definition for the alias. If the target database supports it, ER/Studio Data Architect adds this definition as a comment when generating SQL code. The maximum length of comments in the DDL is 254 characters.
DDL page/tab
Displays the CREATE ALIAS statement needed to build the alias. ER/Studio Data Architect uses the platform-specific parser of the model's selected database platform to generate the alias.
Attachment Bindings tab
Bind an external piece of information or attachment to the alias. You can also remove an attachment from an object, override an attachment binding's default value, or change the position of a bound attachment. To override the value of the attachment you moved to the Selected Attachments grid, double-click the Value field of the target attachment. ER/Studio Data Architect opens the Value Override Editor or a list depending on the attachment datatype. Attachments are created in the Attachments folder of the Data Dictionary and must be applied to the alias before they appear on this tab. For more information, see Attaching External Documents to the Data Model.