View previous topic :: View next topic
|
Author |
Message |
cvijay784 Warnings : 1 New User
Joined: 18 Jun 2008 Posts: 54 Location: Colombo
|
|
|
|
Hi,
I would like to know the difference between the sqlcodes -805 and -818.
I read that -805 occurs due to mismatching consistency tokens between load module and DBRM/Package. And -818 is due to timestamp mismatch between Object Module and DBRM/Package.
Are the consistency tokens and timestamp are same or different? Please clarify.
Thanks
Vijay |
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
-013 |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6248 Location: Mumbai, India
|
|
|
|
+013? I like it - it's positive, jsut a warning for DB2. |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8796 Location: Welsh Wales
|
|
|
|
Bill, that only works if you use -805 = -818 - -13 |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6248 Location: Mumbai, India
|
|
|
|
Jokes apart...
Actually you can find them in google, manuals, QW (if installed) and many other ways to get that, may be these simple definition can help you:
Quote: |
-805 -- DBRM or PACKAGE NAME location-name.collection-id.dbrm-name.consistency -token NOT FOUND IN PLAN plan-name. |
Quote: |
-818 -- THE PRECOMPILER-GENERATED TIMESTAMP x IN THE LOAD MODULE IS DIFFERENT FROM THE BIND TIMESTAMP y BUILT FROM THE DBRM |
|
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
-805 did not bind after compile/linkedit
-818 did not do a new copy in cics. |
|
Back to top |
|
|
vadim vashchenko
New User
Joined: 21 Mar 2011 Posts: 13 Location: usa
|
|
|
|
dbzTHEdinosauer wrote: |
-805 did not bind after compile/linkedit
-818 did not do a new copy in cics. |
What about -805 on DPS? |
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
Apologies. Counldn't avoid the gravitational pull of a set-up line like that.
A Big Boss once asked me "how are we going to get the new report across the road?" meaning to the user-operations department who were physically across the road from our dingy basement - "staple it to a chicken", I replied. Can't resist 'em. |
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Bill Woodger wrote: |
"staple it to a chicken" |
Nice
Regards,
Sushanth |
|
Back to top |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009 Posts: 2481 Location: Netherlands, Amstelveen
|
|
|
|
Bill Woodger wrote: |
"staple it to a chicken" |
Sorry, Bill i had to report this to the Animal Cops. |
|
Back to top |
|
|
anshul_gugnani
New User
Joined: 02 Nov 2009 Posts: 73 Location: Mumbai
|
|
|
|
Hi,
During execution time, your program when encounters a EXEC SQL, it looks for the DB2 instructions (Plan has the DBRM or package name) in the Db2 directory, which has same name as your program ( DBRM or Package). If not found, -805. If found, it checks the consistency tokens match in the load module and Plan, if not matches , -818
Correct me if I am wrong.
Thanks. |
|
Back to top |
|
|
Elixir
Active User
Joined: 08 Feb 2009 Posts: 116 Location: CHENNAI/NEW JERSEY - INDIA/USA
|
|
|
|
After compiling Cobol-DB2(say) Program,if you execute it without Binding then -805 is bound to happen.( )
Once you bind(package) and run the program -805 would be resolved.
When a program (say AAA) is bound, it goes into SYSIBM.SYSPACKAGE
with value of program in NAME( = 'AAA').
After the program is bound, even if you delete the DBRM and try to execute the program it should not face -805. |
|
Back to top |
|
|
|