DB2PLAN

AIX HP-UX Linux OS/2 OS/390 OS/400 PTX 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. See the Administration and Programming Guide for your operating system for more information.

Values

 DB2PLAN="plan_name"

Table 9. DB2PLAN Values
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"


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