Creating nicknames from the Data Source Explorer

You can create nicknames for remote tables from the Data Source Explorer.

Before you begin

Before you can create a nickname for a remote table, you must connect to the federated database.

About this task

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.

Procedure

To create a nickname for a remote table from the Data Source Explorer:

  1. Right-click the remote table and select New Nickname > With SQL Editor. The SQL editor opens.
  2. Edit the CREATE NICKNAME statement.
  3. Right-click in the SQL editor and select Run SQL. The SQL Results view shows the status of this activity.

Feedback