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

Products

• Easytrieve Report Generator
• PAN/SQL

Issue/Introduction

Question: 

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

 

 

Environment

Pan/SQL 2.4C (0203)

Resolution

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 Easytrieve 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.