LOCATION

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"

Table 17. LOCATION Values
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"


[ Top of Page | Previous Page | Next Page | Index ]