Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 
Facing an abend of -805 sql error

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
satishk

New User


Joined: 20 Jul 2007
Posts: 7
Location: Hyderabad

PostPosted: Mon Sep 10, 2007 4:02 pm    Post subject: Facing an abend of -805 sql error
Reply with quote

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
Back to top
View user's profile Send private message

murmohk1

Senior Member


Joined: 29 Jun 2006
Posts: 1439
Location: Bangalore,India

PostPosted: Mon Sep 10, 2007 4:10 pm    Post subject:
Reply with quote

Satish,
Quote:
while executing i am facing an abend of -805 sql error


Let us know the resaon code. If possible post spool messages.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6968
Location: porcelain throne

PostPosted: Mon Sep 10, 2007 4:28 pm    Post subject: Reply to: sql code -805
Reply with quote

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.
Back to top
View user's profile Send private message
satishk

New User


Joined: 20 Jul 2007
Posts: 7
Location: Hyderabad

PostPosted: Tue Sep 11, 2007 11:01 am    Post subject: Re: -805 sql abend
Reply with quote

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
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Sep 11, 2007 8:58 pm    Post subject:
Reply with quote

Hello satish,

When might you post the info Murali requested?
Quote:
Let us know the resaon code. If possible post spool messages.
Back to top
View user's profile Send private message
kodeesm

New User


Joined: 21 Jun 2006
Posts: 3
Location: Pune

PostPosted: Thu Sep 13, 2007 1:42 pm    Post subject: Reply to: Facing an abend of -805 sql error
Reply with quote

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
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts C03 ABEND sjiraga PL/I & Assembler 1 Thu Jun 01, 2017 4:51 pm
No new posts DB2 Program abending without giving a... rahulgarg14 DB2 7 Mon May 29, 2017 8:10 pm
No new posts Getting error while opening a variabl... apandey1 COBOL Programming 5 Fri May 05, 2017 12:22 pm
No new posts IDC2902I Error tzeche ABENDS & Debugging 2 Tue Mar 28, 2017 11:39 am
No new posts Need help with below DB2 error ashek15 DB2 3 Sat Mar 18, 2017 5:56 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us