What is the format for overriding values in the //PAN$SQL DD statement?

Document ID : KB000024620
Last Modified Date : 14/02/2018
Show Technical Document Details

Question: 

What is the format for overriding values in the //PAN$SQL DD statement?

Environment:  

CA Pan/SQL 2.4C

Answer: 

The PLAN and SSID parameters are used only when the CALL ATTACH FACILITY is used to establish a DB2 connection. If the keyword TSO is specified, then PLAN and SSID are ignored.

Valid parameters for the PAN$SQL file are the following:

PLAN=pppppppp - provide the name of the DB2 plan for execution

SSID=ssss - provide the name of the DB2 subsystem to use for a connection.

TSO - indicates that you want to execute your CA-Easytrieve Plus program under the Terminal Monitor Program (TSO) in background mode. You must provide the correct JCL.

The following are two examples of JCL when overriding the PAN$SQL statement:

//PAN$SQL DD * 
   PLAN=TESTPLAN,SSID=D510 
 
//PAN$SQL DD * 
   TSO

Additional Information:

 

Most commonly, you can code a //PAN$SQL DD statement to provide a plan name and DB2 SSID subsystem to be used at the time of your execution.

The PAN$SQL DD file is processed only when executing statically.