How to dynamically specify an SSID under Easytrieve Plus 6.4 0311.

Products

• Easytrieve Report Generator
• PAN/SQL

Issue/Introduction

How to dynamically code SSID under Easytrieve Plus release 6.4 0311

 

Environment

Easytrieve Plus Report Generator, release 6.4 0311

Pan/SQL 2.4C

Resolution

To dynamically pick up the SSID option, please

1. leave SSID blank in the Options Table (default)
   
   
2. remove SSID from the program
   
   
3. then the JCL must point to a library with the DB2 module called DSNHDECP.

With release 6.4, please concatenate the DB2 SDSNEXIT load library ahead of the DB2 SDSNLOAD library so that Easytrieve can get the SSID from the DSNHDECP module in the SDSNEXIT library.

When Easytrieve does not have the SDSNEXIT library first, Easytrieve searches the SDSNLOAD library, which has a DSNHDECP module, but has the value of DSN at the point Easytrieve needs the SSID.