B204 SQL - DB2 SUBSYSTEM "DSN" DOES NOT EXIST error

Products

• Easytrieve Report Generator
• PAN/SQL

Issue/Introduction

 

How to resolve the following error when running an Easytrieve Db2 program:
    B204 SQL - DB2 SUBSYSTEM "DSN" DOES NOT EXIST error

 

 

Environment

Pan/SQL 2.4C

Resolution

The DB2 SDSNEXIT is not being searched first in the order of libraries and therefore not picking up the correct SSID in the DSNHDECP module.

Please concatenate the DB2 SDSNEXIT load library ahead of the DB2 SDSNLOAD library so that the SSID from the DSNHDECP module in the SDSNEXIT library is being picked up.