IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Informationa bout sql code -805


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
karthik1680
Warnings : 2

New User


Joined: 14 May 2005
Posts: 64
Location: chennai

PostPosted: Thu Oct 20, 2005 7:43 am
Reply with quote

explain detaily about -805 error code . i searched the forum but i did'nt get proper answer.
Back to top
View user's profile Send private message
sairam

New User


Joined: 30 Aug 2005
Posts: 58
Location: Kolkata

PostPosted: Thu Oct 20, 2005 9:33 am
Reply with quote

Hi Karthik

Generally this error code occurs when you give a pragram name in the bind jcl which is not found.So check whether the name of the program in the bind jcl correct or not.

You can check it in errorcode descriptor.
Back to top
View user's profile Send private message
pradeepspim

New User


Joined: 18 Oct 2005
Posts: 5
Location: Bangalore

PostPosted: Thu Oct 20, 2005 9:44 am
Reply with quote

hi dude...i think its related to plan...
DBRM or package not found in plan
Is plan name correct?
Back to top
View user's profile Send private message
ANIKET

New User


Joined: 28 Apr 2005
Posts: 11
Location: PUNE

PostPosted: Thu Oct 20, 2005 2:18 pm
Reply with quote

Hey karthik,

-805 will occur when you run your program without binding it properly in to your test region. Some times it may happen that you compiled your program but there are still some SQL errors which compiler cant locate that time during binding it fails. And when you try to run this program you will hit by ?805. The other common reason is that when you compile your program but forget to bind it, then while execution it will fetch the old edition and due to time stamp mismatch you get ?805.
If you want to check the time stamp just go to your LOADLIB library and check for the time stamp. Now if this time stamp not matches with the timestamp in SYSIBM.SYSPACKAGES for that program then you will get ?805.
Back to top
View user's profile Send private message
senthil1711
Warnings : 1

New User


Joined: 27 Feb 2008
Posts: 10
Location: bangalore

PostPosted: Wed Mar 05, 2008 11:22 am
Reply with quote

hi,
this is due to bind fail or bind region may not be different
Back to top
View user's profile Send private message
senthil1711
Warnings : 1

New User


Joined: 27 Feb 2008
Posts: 10
Location: bangalore

PostPosted: Wed Mar 05, 2008 11:23 am
Reply with quote

hi..

sorry small correction in above reply..

'bind region may be different'
Back to top
View user's profile Send private message
abhishek mitra

New User


Joined: 24 Feb 2008
Posts: 48
Location: Kolkata

PostPosted: Wed Mar 05, 2008 12:25 pm
Reply with quote

Hi karthik1680,

Just bind your module in proper region using your LOADlibrary and DBRM library. It will pick up the proper package then. Doing this should solve your problem.

thanks
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Cobol code- to find a string in a str... COBOL Programming 3
No new posts IEF085I REGION UNAVAILABLE,ERROR CODE... Java & MQSeries 0
No new posts How to convert RESP code 12 to text? CICS 9
No new posts Execute step regardless of previous s... JCL & VSAM 2
No new posts Error 0C1 Reason Code 1 with branch i... PL/I & Assembler 3
Search our Forums:

Back to Top