Aliases Wizard (DB2 LUW)

From DBArtisan
Jump to: navigation, search

Go Up to IBM DB2 for Linux, Unix, and Windows Object Wizards

An alias offers you security and convenience so that you can refer to an object without revealing who owns it or what database it belongs to. You can create aliases for tables, views, and even other aliases. The Alias Wizard lets you create an alias without knowing the underlying commands. As you complete the Alias Wizard process, a CREATE ALIAS statement is generated based on the information that you supply.

To create a new alias using a wizard:

  1. Open a creation wizard for an alias. For details, see Opening an Object Wizard.
  2. Use the following topics as a guide to setting properties and performing tasks as you pass through the wizard panels:
  3. Finally, use the Execute button to create the object.

Aliases (DB2 LUW) - Properties

When creating or editing an alias, this tab/panel lets you work with the following settings:

Setting Description


Select the schema that is to own the alias.


Provide a name for the alias

Target Owner

Select the owner of the object to which you are creating an alias.

Target Type

Select the type of object to which you want to create an alias.

Target Name

Select the specific object to which you are creating an alias.

For context information on the wizard and editor that include this tab/panel, see Aliases Wizard (DB2 LUW) and Aliases Editor (IBM DB2 LUW).