View previous topic :: View next topic
|
Author |
Message |
arunshan04
New User
Joined: 25 Apr 2009 Posts: 25 Location: chennai
|
|
|
|
can any one explain the situation for this sqlcode how it will differ? |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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 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.
publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/handheld/Connected/search
This incomplete - please see later post, d |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
Mr Scherrer,
I can only hope that someday I can attain your level of control. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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. . .
I'm still working on it, but it is slow coming. . .
Have a great weekend!
d |
|
Back to top |
|
|
arunshan04
New User
Joined: 25 Apr 2009 Posts: 25 Location: chennai
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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. . .
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.
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 |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
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 |
|
|
Shriram Jogdand
New User
Joined: 14 Oct 2008 Posts: 65 Location: Pune
|
|
|
|
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 |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
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 |
|
|
|