-
Open the Create Alias window:
-
Right-click on the Aliases folder in the object tree.
-
Select Create from the pop-up menu.
-
In the Alias owner field, specify the user ID for the owner of the
alias.
Tip: To display a list of existing objects, click on the 
(Browse) button next to the field. Select an existing object from the list.
-
In the Alias name field, type a name for the alias that you are
creating. This name cannot identify an existing table, view, alias, or
synonym on the current server.
-
In the Object location field, specify the location of the object
for which you are creating an alias.
-
If you leave this field blank, the alias for an object at the current server,
is created with a two-part name. For example, the alias, myalias,
which is owned by the user ID, userid, and is for an object on the
current server is named: userid.myalias.
-
If you specify the name of another server, then the alias is created with
a three-part name. For example, the alias, myalias, which is owned
by the user ID, userid, and is for an object on the server, DB2XYZ123
is named: DB2XYZ123.userid.myalias.
-
In the Object owner field, type the owner of the object for which
you are creating an alias.
-
In the Object name field, type the name of the object for which
you are creating an alias.
Important: If you are defining an alias for an object on a different
server, then existence of this object is not verified when the alias is
created. If this object does not exist, statements that include this alias
will not run properly.
-
Optional: In the Comment field, type a description of the alias.
You can type up to 254 characters.
-
Click OK to commit your change.
Authorities and privileges
