|
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: 6250
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: 8797
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: 6250
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 |
|
|
|
|
