AIX | HP-UX | Linux | OS/2 | OS/390 | OS/400 | PTX | SUN | Win NT |
|
|
|
| X |
|
|
|
|
Purpose
Establishes a connection to a local DB2 subsystem. The variable specifies the subsystem ID of the local DB2 subsystem that Net.Data will access. Only one local database connection is allowed for each macro.
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.
Values
DB2PLAN="subsytem_id"
Values | Description |
---|---|
subsystem_id | The name of the DB2 subsytem. The name can be eight characters or less. |
Examples
Example 1: Specifies a subsystem ID in the DEFINE statement
%DEFINE DB2SSID="DBNC"