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.
To create a nickname for a remote
table from the Data Source Explorer:
- Right-click the remote table and select . The SQL editor opens.
- Edit the CREATE NICKNAME statement.
- Right-click in the SQL editor and select Run SQL.
The SQL Results view shows the status of this activity.