Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Difference between sqlcode -805 and -818

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
arunshan04

New User


Joined: 25 Apr 2009
Posts: 25
Location: chennai

PostPosted: Fri Nov 13, 2009 10:05 pm    Post subject: Difference between sqlcode -805 and -818
Reply with quote

can any one explain the situation for this sqlcode how it will differ?
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sat Nov 14, 2009 12:59 am    Post subject:
Reply with quote

Hello,

The difference is 13. . .

Did you even look at these error codes? The explanation of the "difference" is quite straightforward. . . They are so completely unrelated that i'm not sure why "difference" is an issue icon_confused.gif Unless there is something i misunderstand.

Use this link and search for -805, then -818. If you find something that is not clear, post what you found and your doubt. Someone will be able to clarify.
http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/handheld/Connected/search
This incomplete - please see later post, d
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6968
Location: porcelain throne

PostPosted: Sat Nov 14, 2009 3:25 am    Post subject:
Reply with quote

Mr Scherrer,

I can only hope that someday I can attain your level of control.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sat Nov 14, 2009 3:35 am    Post subject: Reply to: Difference between sqlcode -805 and -818
Reply with quote

Hi Dick,

Quote:
I can only hope that someday I can attain your level of control.
I hope i attain that level someday as well. . . icon_wink.gif

I'm still working on it, but it is slow coming. . .

Have a great weekend!

d
Back to top
View user's profile Send private message
arunshan04

New User


Joined: 25 Apr 2009
Posts: 25
Location: chennai

PostPosted: Sun Nov 15, 2009 11:28 pm    Post subject:
Reply with quote

i am binding package directly in to the plan.
at the run time when the package is not there its giving -805.

so at which situation it will give -818?

and also if i bind the dbrm directly in to plan
at the run time what will give if the same situation occurs.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon Nov 16, 2009 12:43 am    Post subject:
Reply with quote

Hello,

Looks like no one found the "bug" i posted earlier (or at least no one reported it). . .

The search link i gave above appears not to work unless the manual is already open. This link is the table of contents for messages and codes for db2. Use this link, then search. . .
http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/handheld/Connected/BOOKS/DSNMCJ11/CONTENTS?

Sorry 'bout the misdirection. When i gave the link, the manual was already open and so i missed the disconnect. Ugh. . .

Quote:
so at which situation it will give -818?
The -818 is a timestamp problem. As i messed up the first attempt to show how to find the info, here's the direct link to the -818 info. Note that the -818 is not at all like the -805.
http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/handheld/Connected/BOOKS/dsnmcj10/2.1.6.405

Why are you interested in the -818 if the current issue is an -805?

Suggest you spend some time with your dba and learn how things are intended to work in your environment.
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Mon Nov 16, 2009 1:27 pm    Post subject:
Reply with quote

A possible cause of -805 is to precompile a program without a bind.
A possible casue of -818 is to precompile a program without a bind.

The difference is the LEVEL option during precompile and thus the version (and consistency token) used.
Back to top
View user's profile Send private message
Shriram Jogdand

New User


Joined: 14 Oct 2008
Posts: 65
Location: Pune

PostPosted: Mon Nov 16, 2009 5:50 pm    Post subject: Reply to: Difference between sqlcode -805 and -818
Reply with quote

Hi,

You will get -818 when you have modified the program and forgot to bind the plan again. If you ran with the same plan then you will get -818.

When if any of your plan is not present or you forgot to bind any of the plan's package whose program is modified, then you will get -805.

Thanks.
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Mon Nov 16, 2009 7:01 pm    Post subject: Re: Reply to: Difference between sqlcode -805 and -818
Reply with quote

Shriram Jogdand wrote:
You will get -818 when you have modified the program and forgot to bind the plan again. If you ran with the same plan then you will get -818.
As I already implied :
Only when you've precompiled with LEVEL : then you will get an -818, otherwise the version (and contoken) will get modified and without a bind the new package (=Location,collid,name,contoken) will not be found and a -805 will be raised.
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
No new posts Difference in SORT & ICETOOL Mohan Kothakota DFSORT/ICETOOL 4 Fri Sep 22, 2017 4:56 pm
No new posts DB2 SQL Error: SQLCODE=-440, SQLSTATE... kishpra DB2 1 Sat Feb 18, 2017 2:31 am
No new posts Difference between TWALENG and TWASIZE Arunkumar Chandrasekaran CICS 3 Tue Jan 03, 2017 12:57 pm
No new posts Sticky: difference between ... DUMMY ... and ... enrico-sorichetti JCL & VSAM 0 Mon Oct 17, 2016 4:31 pm
No new posts Difference space showed for TS and it... autobox DB2 1 Thu Apr 14, 2016 1:07 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us