Facing an abend of -805 sql error

satishk · New User Joined: 20 Jul 2007 Posts: 7 Location: Hyderabad

Hi friends,
I am working with a customer-add,update,delete program in cobol under cics.while executing i am facing an abend of -805 sql error. but, my plan name and its dbrmlib were all well ok.
so, still while i am updating an customer number, i am not able to visualize the customer number and its contents.
so, i would request you to plz give me proper reply.

with regards,
satish

murmohk1 · Posted: Mon Sep 10, 2007 4:10 pm

Satish,

dbzTHEdinosauer · Posted: Mon Sep 10, 2007 4:28 pm

you should get in the habit of displaying/logging the contents of sqlda whenever you receive a negative sqlcode.

Since you are working in the CICS environment and you are sure that the compile/link/bind process was complete and error free, then insure that you managed to effect a NEWCOPY of the load module in the CICS region in which you are working. You should also insure that the bound load is in the loadlib referenced by the CICS Start JCL.

satishk · New User Joined: 20 Jul 2007 Posts: 7 Location: Hyderabad

Hi Dick Brenholtz,

This is Satishk.well, i agree with your answer, but i would like to inform you that i have loaded my program in my loadlib.And i even set that program each time i have made my application to execute, to ensure my updates in my cobl program.
so, my solution to application is not yet got solved.
i think you got it.

with regards,
satishk

dick scherrer · Posted: Tue Sep 11, 2007 8:58 pm

Hello satish,

When might you post the info Murali requested?

kodeesm · New User Joined: 21 Jun 2006 Posts: 5 Location: Pune

Hi Sathish,

I was faced this problem when I started working with the CICS. I have done the following steps and avoided the -805.

1. Check for the region(if you are having different CICS region) to which you compiled the program.
2. Release the already existing program versions from the CICS region.
3. After that make a new copy and start working.

If you are still facing the same problem, then please let us know.

Thanks & Regards
Kodeeswaran M