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
 

 

What is the difference between SQLCODES -805 and -818?

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

New User


Joined: 18 Jun 2008
Posts: 54
Location: Colombo

PostPosted: Tue Apr 19, 2011 5:05 pm    Post subject: What is the difference between SQLCODES -805 and -818?
Reply with quote

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
View user's profile Send private message

Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7223

PostPosted: Tue Apr 19, 2011 7:36 pm    Post subject:
Reply with quote

-013
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Tue Apr 19, 2011 8:46 pm    Post subject: Reply to: What is the difference between SQLCODES -805 and -
Reply with quote

+013? I like it - it's positive, jsut a warning for DB2.
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Tue Apr 19, 2011 8:57 pm    Post subject:
Reply with quote

Bill Woodger wrote:
-013


Bill, that only works if you use -805 = -818 - -13 icon_lol.gif
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Tue Apr 19, 2011 9:28 pm    Post subject:
Reply with quote

Jokes apart...icon_smile.gif

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
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


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

PostPosted: Tue Apr 19, 2011 9:36 pm    Post subject:
Reply with quote

-805 did not bind after compile/linkedit
-818 did not do a new copy in cics.
Back to top
View user's profile Send private message
vadim vashchenko

New User


Joined: 21 Mar 2011
Posts: 13
Location: usa

PostPosted: Tue Apr 19, 2011 10:13 pm    Post subject:
Reply with quote

dbzTHEdinosauer wrote:
-805 did not bind after compile/linkedit
-818 did not do a new copy in cics.


What about -805 on DPS? icon_confused.gif
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7223

PostPosted: Wed Apr 20, 2011 2:51 am    Post subject:
Reply with quote

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
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Thu Apr 21, 2011 2:38 am    Post subject:
Reply with quote

Bill Woodger wrote:
"staple it to a chicken"

Nice

Regards,
Sushanth
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2422
Location: Netherlands, Amstelveen

PostPosted: Thu Apr 21, 2011 1:14 pm    Post subject:
Reply with quote

Bill Woodger wrote:
"staple it to a chicken"


Sorry, Bill i had to report this to the Animal Cops.
Back to top
View user's profile Send private message
anshul_gugnani

New User


Joined: 02 Nov 2009
Posts: 73
Location: Mumbai

PostPosted: Thu Apr 21, 2011 4:50 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Elixir

Active User


Joined: 08 Feb 2009
Posts: 116
Location: CHENNAI/NEW JERSEY - INDIA/USA

PostPosted: Fri Apr 29, 2011 3:17 pm    Post subject:
Reply with quote

After compiling Cobol-DB2(say) Program,if you execute it without Binding then -805 is bound to happen.( icon_biggrin.gif )

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
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 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
No new posts Difference Between CICS WebSupport an... sachinji84 CICS 1 Mon Mar 07, 2016 7:25 pm
No new posts Difference between -180 and -181 with... deepak_shrivastava DB2 4 Wed Jan 06, 2016 10:00 am
No new posts Difference between COBOL for MAINFRAM... dejunzhu COBOL Programming 1 Sat Oct 31, 2015 2:18 pm


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