Online Documentation for SQL Manager for DB2

Nicknames


A Nickname is an identifier that a federated server uses to refer to a data source table or view.

 

 

Creating Nicknames

 

To create a new nickname:

Hint: To create a new nickname, you can also right-click the Nicknames node of the DB Explorer tree and select the New Nickname... context menu item.

 

To create a new nickname with the same properties as one of existing nicknames has:

Alternatively, you can right-click a nickname in the DB Explorer tree and select the Duplicate Nickname <nickname_name>... context menu item.

 

Duplicate Object Wizard allows you to select the database to create a new nickname in, and to edit the result SQL statement for creating the nickname.

 

 

Editing Nicknames

 

To edit an existing nickname:

  • select the nickname for editing in the DB Explorer tree (type the first letters of the nickname name for quick search);
  • right-click the object and select the Edit Nickname <nickname_name>... context menu item, or simply double-click the nickname;
  • edit nickname definition using the appropriate tabs of Nickname Editor.

 

Dropping Nicknames

 

To drop a nickname:

  • select the nickname to drop in the DB Explorer tree;
  • right-click the object and select the Drop Nickname <nickname_name>... context menu item;
  • confirm dropping in the dialog window.

 

Note: If more convenient, you can also use the following shortcuts:

Ctrl+N to create a new nickname;

Ctrl+O to edit the selected nickname;

Shift+Del to drop the object from the database.