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

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

book

Article ID: 53025

calendar_today

Updated On:

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.