Easytrieve plus with idms sql getting is getting a B204 SQL - INTRNL ERR 9034 ALLOC SQLDS

book

Article ID: 16778

calendar_today

Updated On:

Products

CA PanAudit Plus CA Easytrieve Report Generator CA PAN/SQL

Issue/Introduction

Trying to run Easytrieve for IDMS



Why am I getting the following on my compile?

*******B204 SQL - INTRNL ERR 9034 ALLOC SQLDS   

*******B204 SQL - INTRNL ERR 9903                

 

Environment

Easytrieve running with IDMS

Resolution

Easytrieve for IDMS was not installed on the LPAR you are running.

 PanSQL IDMS installation is not the PanSQL DB2 installation. 

 

The following is a sample setup running Easytrieve for IDMS

//STEPLIB DD DISP=SHR,DSN=your.eztp.loadlib 
// DD DISP=SHR,DSN=your.idms.loadlib 
// DD DISP=SHR,DSN=pansql.idms.loadlib

 

Additional Information

See chapter "CA-IDMS with SQL" in the "CA-Pan/SQL Getting Started 2.4C" - page 80ff. 
It's required when using SQL to access IDMS data bases. 
It's not required when using native IDMS commands - see "IMS/DLI Interface Option Guide 6.4".