DB2SSID

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"

Table 10. DB2SSID Values
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"


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