AIX | HP-UX | Linux | OS/2 | OS/390 | OS/400 | SCO | SUN | Win NT |
|
|
|
| X |
|
|
|
|
Purpose
Allocates a plan for a connection to a local DB2 subsystem. The variable specifies the name of a plan for the Net.Data SQL language environment at the local DB2 subsystem that Net.Data will access.
Specify the value of this variable using a DEFINE statement or with the @DTW_ASSIGN() function.
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.
Values
DB2PLAN="plan_name"
Values | Description |
---|---|
plan_name | The name of the DB2 plan. The name can be eight characters or less. |
Examples
Example 1: Specifies the plan in the DEFINE statement
%DEFINE DB2PLAN="DTWGAV22"