Creating nicknames from the Data Project Explorer

You can create nicknames for remote tables that are imported to the Data Project Explorer.

A nickname is a name that is defined in WebSphere® Information Integrator to represent a physical database object (such as a table or stored procedure) in a non-DB2 relational database.

To create nicknames for remote tables from the Data Project Explorer, you must import the remote schemas and the remote tables in those schemas from the Data Source Explorer to a data design project in the Data Project Explorer. If you did not import the remote schema, you can create a schema by right-clicking the federated database and selecting Add Data Object > Schema.

You can create nicknames from the Data Project Explorer by right-clicking the remote schema or the remote table and selecting the appropriate menu item.

To create a nickname from the remote schema:

  1. Right-click the remote schema and select Add Data Object > Nickname. The Nickname window opens.
  2. In the Nickname window, select the check boxes for the tables that you want to create nicknames for. To select all of the tables in a database, click Select All. To clear your selections, click Deselect All.

To create a nickname from the remote table:

  1. Right-click the remote table and select Create Nickname. The Create Nickname window opens.
  2. In the Create Nickname window, select the schema of the federated database and type a nickname for the table.
Related tasks
Creating nicknames from the Data Source Explorer
Related information
Create Nickname
Nickname

Feedback