Registering nicknames for Sybase tables and views

For each Sybase server definition that you register, you must register a nickname for each table or view that you want to access. Use these nicknames, instead of the names of the data source objects, when you query the Sybase servers.

Before you begin

Update the statistics at the Sybase data source before you register a nickname. The federated database relies on the data source catalog statistics to optimize query processing. Use the data source command that is equivalent to the Db2® RUNSTATS command to update the data source statistics.

Procedure

Issue the CREATE NICKNAME statement from the command line.

For example:

CREATE NICKNAME nickname 

FOR server_definition_name."remote_schema"."remote.table" ;

Nicknames can be up to 128 characters in length.

When you create the nickname, the federated server queries the data source catalog by using the nickname. This query tests the connection to the data source table or view. If the connection does not work, you receive an error message.

What to do next

Repeat this step for each Sybase table or view that you want to create a nickname for.