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
 
Informationa bout sql code -805

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: Informationa bout sql code -805
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    Post subject:
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    Post subject: Re: sql code -805
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    Post subject:
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    Post subject:
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    Post subject:
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    Post subject:
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    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
This topic is locked: you cannot edit posts or make replies. how to code for GDG in Rexx cvnlynn CLIST & REXX 13 Wed Aug 09, 2017 9:13 pm
This topic is locked: you cannot edit posts or make replies. rexx code to create a ps file Bharath Vikraman CLIST & REXX 4 Mon Aug 07, 2017 10:30 am
No new posts I want to retire TRX and use only Rex... Abhinav Sharma CLIST & REXX 6 Sat Jul 29, 2017 2:53 am
No new posts UNIT=AFF for Easytrieve code gandikk JCL & VSAM 7 Wed Jul 12, 2017 11:42 pm
No new posts DB2 Program abending without giving a... rahulgarg14 DB2 7 Mon May 29, 2017 8:10 pm


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