Previous Topic: Define a DB2 LUW Trusted ContextNext Topic: Define a DB2 LUW Table


Define a DB2 LUW Alias

You can work with table alias names when you click the Alias tab in the Table editor. If you are using DB2 for LUW version 9.7, you can add aliases for sequences, modules, and tables.

To define a DB2 LUW Alias

  1. Open the Table Editor and click the Alias tab.
  2. Select a synonym name and click the Alias Editor icon.

    The DB2 for LUW Alias Editor opens.

  3. Work with the following options:

    Note: Click New New icon in property editors to create a new object on the toolbar to create a synonym.

    Name

    Specifies the name of the synonym.

    Schema

    Specifies the schema to associate with the selected synonym. Select a schema from the drop-down list.

    Public

    Specifies whether or not the alias is an object in the SYSPUBLIC system schema.

    Use Replace Syntax

    Specifies that Forward Engineering will use the CREATE or REPLACE command instead of the CREATE command.

    Note: The Public and Use Replace Syntax fields apply to DB2 for LUW version 9.7 only.

    Generate

    Generates DDL for this object during Forward Engineering.

  4. Click the Alias tab and work with the following options:
    Name

    Specifies the name of the alias for the selected alias.

    Schema

    Specifies the schema for the selected alias. Select from the drop-down list.

  5. (Optional) Click the Comment tab and enter any comments that you want to associate with the object.
  6. (Optional) Click the UDP tab to work with user-defined properties for the object.
  7. (Optional) Click the Notes tab to view and edit user notes.
  8. Click Close.

    The Alias Editor closes.