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
 

 

SQLcode -805 when running the cobol-db2 program

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> ABENDS & Debugging
View previous topic :: :: View next topic  
Author Message
Vishwamurthy

New User


Joined: 11 Mar 2008
Posts: 57
Location: India

PostPosted: Wed Dec 14, 2011 7:13 pm    Post subject: SQLcode -805 when running the cobol-db2 program
Reply with quote

I get a similar STATUS: -0805 error. Below are the error details:
DBRM OR PACKAGE NAME
DB2SSID..PROGRAM.<HEX> NOT FOUND IN PLAN PROGRAM.

I tried 1. Deleting the test cobol, 2. Re-generating the cobol, 3. External bind but it doesn't help me in any way. Same old error message.
Please help me..

I don't understand "Show your package and plan bind control cards and sysouts". Bind is always successful..
Back to top
View user's profile Send private message

Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1771
Location: Bloomington, IL

PostPosted: Wed Dec 14, 2011 8:09 pm    Post subject: Re: SQLcode -805 when running the cobol-db2 program
Reply with quote

Vishwamurthy wrote:
I don't understand "Show your package and plan bind control cards and sysouts". Bind is always successful..

In that case, you must be only imagining the -805 SQLCODE. I can't help you, as I'm a software developer, not a psychiatrist.
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Wed Dec 14, 2011 8:25 pm    Post subject:
Reply with quote

Maybe you are running with an old load module ?
or against the wrong subsystem ?
Back to top
View user's profile Send private message
daveporcelan

Active Member


Joined: 01 Dec 2006
Posts: 670
Location: Pennsylvania

PostPosted: Wed Dec 14, 2011 9:02 pm    Post subject:
Reply with quote

From my experience, the number one cause of a -805 is:

The library concatenation used in the Bind (step 3 for you above) does not match the library concatenation used in your Batch Job or CICS region setup.

Show the JCL you used for your external bind and your Batch run.
Back to top
View user's profile Send private message
don.leahy

Active Member


Joined: 06 Jul 2010
Posts: 655
Location: Whitby, ON, Canada

PostPosted: Wed Dec 14, 2011 10:12 pm    Post subject:
Reply with quote

Possibly the online region(s) needs to be refreshed to ensure that the latest version of the load module is loaded. This often happens in IMS MPRs. (I don't speak CICS).

However, the TS hasn't given us any information about the execution environment, so this is just speculation.

I was going to suggest that this question would be more suited to the beginner's forum, but then I remembered that I have known veteran programmers whose solution to every -805 problem was to keep binding the program over and over in the hopes that it would eventually work.
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 -> ABENDS & Debugging All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts XML Parse for COBOL 5.2 Bhanu Praveen COBOL Programming 1 Sat Jul 08, 2017 8:58 pm
No new posts Writing a file using online program grvtomar PL/I & Assembler 3 Fri Jun 30, 2017 1:06 pm
No new posts pre-compiler for program in an HFS Pedro DB2 0 Fri Jun 23, 2017 11:13 pm
No new posts Dynamic output file creation in cobol... smileheal COBOL Programming 7 Thu Jun 15, 2017 10:53 pm
No new posts Search utility(3.14) using JCl and Cobol RKS3 COBOL Programming 12 Sat Jun 10, 2017 10:24 pm


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