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
 

 

When and how do we get the sql code -805

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions
View previous topic :: :: View next topic  
Author Message
ranjithasumesh
Currently Banned

New User


Joined: 16 Mar 2007
Posts: 3
Location: chennai

PostPosted: Thu Mar 22, 2007 9:00 am    Post subject: When and how do we get the sql code -805
Reply with quote

when and how do we get the sql code -805
Back to top
View user's profile Send private message

mohitsaini
Warnings : 1

New User


Joined: 15 May 2006
Posts: 90

PostPosted: Thu Mar 22, 2007 9:49 am    Post subject: Re: sql code -805
Reply with quote

I just looked into the abend assist and this is what i found:

An attempt was made to execute the application program 'location name.collection id.program name.consistency token' (this token can be 'location name..program name.consistency token' if the current package set special register is blank for the local program execution) that has not been found due to one or more or the following reasons: * The program 'program name' has not been bound as the member part of the application plan 'plan name' or * The 'collection id' in the PKLIST was not correct when the application plan 'plan name' was bound or * The current package set special register was not set correctly or * The 'location name' in the CURRENTSERVER was not correct when the application plan 'plan name' was bound, or * The application was not connected to the proper location or * The location id in the package list was not correct when the application 'plan name' was bound or * The DBRM of the version of the application program being executed was not bound.
Back to top
View user's profile Send private message
prakash271082

New User


Joined: 09 Sep 2005
Posts: 53

PostPosted: Thu Mar 22, 2007 10:38 am    Post subject:
Reply with quote

Hi,

You get -805 SQL CODE when your program name is not found in plan, which you are trying to execute.
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 -> Mainframe Interview Questions All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts JCL to Set Return code based on DB2 S... vinu78 DB2 17 Mon Mar 13, 2017 9:47 pm
No new posts IMS region inactive - User abend code... gthmrj IMS DB/DC 5 Tue Mar 07, 2017 12:29 pm
No new posts CA Workload Automation event code help vinu78 CA Products 10 Wed Mar 01, 2017 10:05 am
No new posts MAX-RC 88 and Return code 606 in DFH0... lind sh CICS 2 Tue Jan 24, 2017 1:23 pm
No new posts How to Capture the Max return code of... anilkumar922 All Other Mainframe Topics 2 Thu Jan 12, 2017 12:02 pm


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