LOCATION=

LOCATION=

Enables you to further qualify exactly where a table resides.

Default value: None

Syntax
Details

Syntax

LOCATION=location

Details

The location name maps to the location in the SYSIBM.SYSLOCATIONS catalog in the communication database.

In the DB2 engine, the location is converted to the first level of a three-level table name: LOCATION.AUTHID.TABLE. The connection to the remote DB2 subsystem is done implicitly by DB2 when DB2 receives a three-level name in an SQL statement.

If you specify LCOATION=, you must also specify the AUTHID= option.

Chapter Contents
Previous
Next
Top of Page