Use the CREATE NICKNAME statement and the required nickname options
to register a nickname for an DB2® table or view that you want to access.
This example shows the use of the required options for the CREATE
NICKNAME statement. You can also include additional nickname and column options.
CREATE NICKNAME DB2SALES FOR DB2SERVER.VINNIE.EUROPE
- DB2SALES
- A unique nickname that identifies the DB2 table or view. The nickname can include
both a schema and the nickname. If you omit the schema, the authorization
ID of the user who registers the nickname is used.
- DB2SERVER.VINNIE.EUROPE
- A three-part identifier for the remote object:
- DB2SERVER is the name that you assigned to the DB2 database
server in the CREATE SERVER statement.
- VINNIE is the user ID of the owner of the table or
view. This value is case sensitive.
- EUROPE is the name of the remote table or view that
you want to access.