Online Documentation for SQL Manager for DB2

Creating/editing nickname

Use the Nickname tab of Nickname Editor to create/edit a nickname and specify its definition.

Nickname schema

Use the drop-down list to select the schema for the new nickname.

Nickname name

Enter a name for the new nickname. The nickname specifies the federated server's identifier for the object at the data source.

Server properties

Name

Use the drop-down list to select a server that was registered when creating server. This server will be used to access the data for the nickname.

Type

Use the drop-down list to specify the type of the server denoted by Name.

Version

Specifies the version of the server that will be used to access the data for the nickname.

Object properties

Schema

Set the name of the schema for the object used by the nickname.

Name

Specify an identifier to define the remote object name.