MVSFORUMS.com :: View topic - DB2 Call Level Interface error

through

#1: DB2 Call Level Interface error Author: somuk,

Posted: Tue Jul 22, 2003 8:36 am
—
Hi ,
I'm getting the following error when running a COBOL-DB2 program.
I'm not able to understand the reason for this. Can anybody help me
out..?

Code:

"Error messages seen in job log: +IDI0082E DB2 Call Level Interface error: SQL return code -1 for SQLAllocConnect to DB2 system DSFP
A system abend 04E occurred in an undetermined module.
A DB2 reason code X'00E70007' is associated with this abend and indicates that:
A bad application-supplied address was encountered while trying to copy SQLCA back to the application program.
SQLCA information: SQLCODE = -804, SQLSTATE = 07002 Explanation for -804: The call parameter list or the SQLDA is invalid.
Sysout directed to SYSOUT = V"

#2: Author: kolusu, Location: San Jose

Posted: Tue Jul 22, 2003 10:25 am
—
Somu,

check if there is any internal table defined in the working storage of the program just before where sqlca is defined.

There is a likely chance that the internal table over flowed and corrupted the contents of sqlca.

Hope this helps...

cheers

kolusu

#3: Author: somuk,

Posted: Tue Jul 22, 2003 11:01 pm
—
Kolusu,
Yes..There is an internal table defined just above the SQLCA definition. I'm going to increase the size of the table and will test it..
Thanks for your timely and valuable suggestion.

MVSFORUMS.com -> Database

output generated using printer-friendly topic mod. All times are GMT - 5 Hours

Page 1 of 1