CREATE NICKNAME statement - Examples for the JDBC wrapper

The example shows how to register a nickname for a JDBC table or view by using the CREATE NICKNAME statement.

This statement specifies the server definition and the remote schema and table:

CREATE NICKNAME cust_europe FOR jdbc_server."vinnie"."italy"

cust_europe

A unique nickname that is used to identify the JDBC table or view. The nickname must be unique within the schema.

Important: The nickname is a two-part name; the schema and the nickname. If you omit the schema when you register the nickname, the schema of the nickname is set to the authorization ID of the user who registers the nickname.

If your JDBC data source does not support schemas, omit the schema from the CREATE NICKNAME statement, for example:

CREATE NICKNAME cust_europe FOR jdbc_server."italy"

jdbc_server."vinnie"."italy"

A three-part identifier for the remote object:

jdbc_server: The server definition name that you assigned to the JDBC data source server in the CREATE SERVER statement.
vinnie: The user ID of the owner to which the table or view belongs.
italy: The name of the remote table or view that you want to access.

The federated server folds the names of the JDBC schemas and tables to uppercase, unless you enclose the names in double quotation marks.