How to link the DB2 command program with the Easytrieve program

Products

• Easytrieve Report Generator
• PAN/SQL

Issue/Introduction

Working on creating a static SQL DB2 program with the JCL working that creates separate load modules for the Easytrieve program and the DB2 Command Program.

On page 144 of the Programming Guide it says:

Static SQL is specified by two parameters on the PARM statement. PLAN specifies the name of the DB2 static-command-program and its plan name. The command program can either be linked with the CA Easytrieve program or linked as a separate load module. A BIND parameter of STATIC-ONLY or ANY causes the static-command-program to be generated. This indicates that these modules could be LINKed into a single load module. I'm looking for an example or documentation on how to do that LINK.

 

 

Environment

Easytrieve Report Generator, release 11.6
Pan/SQL 2.4C

Resolution

The following will Link the DB2 command program with the Easytrieve program, by not specifying a program-name on the LINK statement. 

Instead of: 
//EZCOMP.SYSIN DD *
PARM SSID(DB2I) BIND(STATIC-ONLY) PLAN(SAMP03L) LINK(SAMP03 R)

Don't specify name on the LINK parm: 
//EZCOMP.SYSIN DD *
PARM SSID(DB2I) BIND(STATIC-ONLY) PLAN(SAMP03L) LINK

And keep the name on the IEWL step: 
//LINK.SYSLIN DD *
INCLUDE OBJLIB1
INCLUDE OBJLIB2
NAME SAMP03(R)