AIX | HP-UX | Linux | OS/2 | OS/390 | OS/400 | PTX | SUN | Win NT |
|
|
|
| X |
|
|
|
|
Purpose
Establishes a connection to a remote database server. The variable specifies the name by which the remote server is known to the local DB2 subsystem. The value of LOCATION must be defined in the SYSIBM.SYSLOCATIONS table of the Communications Database (CDB). If this variable is not defined within a macro, any SQL requests made by the macro are executed at the local DB2 subsystem.
Requirement: For the value of this variable in the macro to take effect, it must be listed on the ENVIRONMENT statement for the SQL language environment. See the Administration and Programming Guide for your operating system for more information.
Specify the value of this variable using a DEFINE statement or with the @DTW_ASSIGN() function.
Values
LOCATION="remote_dbase_name"
Values | Description |
---|---|
remote_dbase_name | The name of a valid remote database server that is defined in the SYSIBM.SYSLOCATIONS table of the CDB. The name can be eight characters or less. |
Examples
Example 1: Defines the remote database location in the DEFINE statement
%DEFINE LOCATION="QMFDJ00"