PAN/SQL IVP Return Code 16
search cancel

PAN/SQL IVP Return Code 16

book

Article ID: 95464

calendar_today

Updated On:

Products

PanAudit Plus Easytrieve Report Generator PAN/SQL

Issue/Introduction



Running CA Pan/SQL IVP job and getting the following errors:
   
000140 - 1 FILE SQLFILE SQL + 
000141 2 (SELECT NAME, CREATOR + 
000142 3 FROM SYSIBM.SYSTABLES + 
000143 4 INTO :NAME, :CREATOR) 
000144 EZTC0500E >>> $ host variable not defined 
000145 EZTC0500E >>> $ host variable not defined 
000146 5 SQL INCLUDE LOCATION * FROM SYSIBM.SYSTABLES 
000147 EZTC0441E >>> $ Intrnl Err 9034 ALLOC SQLDS 
000148 EZTC0441E >>> $ Intrnl Err 9903 
000149 EZTC0622E >>> $ SQL statement not processed due to previous errors 
 
What are some ways I can resolve this?

Environment

Release:
Component: PANSQL

Resolution

The supplied JCL was not customized fully for the libraries:
//* THE DB2 LOADLIB //* DD DSN=your.db2.SDSNLOAD,DISP=SHR
Please review your JCL and change any lower case to your appropriate libraries. 
 
If the JCL has been successfully modified to reflect your libraries, then please rebind the package/plan.