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 How to Capture the Max return code of... anilkumar922 All Other Mainframe Topics 0 Thu Jan 12, 2017 12:02 pm
This topic is locked: you cannot edit posts or make replies. Calling REXX code from ISPF panel sanchita dey TSO/ISPF 4 Mon Jan 02, 2017 5:13 pm
No new posts PL/I code tuning/Performance improvement Virendra Shambharkar PL/I & Assembler 4 Mon Dec 05, 2016 11:57 am
No new posts What is the code in CLIST to enable t... jackzhang75 CLIST & REXX 1 Fri Dec 02, 2016 3:02 am
No new posts IDEAL - Code Retrieval yugendran CA Products 0 Fri Nov 25, 2016 3:27 pm


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