IBM Books

Reference

DB2PLAN


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"

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 | Table of Contents | Index ]