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
.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:
To create a nickname from the remote table: