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
 

 

How to solve -818?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> ABENDS & Debugging
View previous topic :: :: View next topic  
Author Message
sabyasachi

New User


Joined: 31 Aug 2006
Posts: 3

PostPosted: Sat Dec 08, 2007 1:57 pm    Post subject: How to solve -818?
Reply with quote

How to solve -818 error?
Back to top
View user's profile Send private message

Gnanas N

Active Member


Joined: 06 Sep 2007
Posts: 785
Location: Chennai, India

PostPosted: Sat Dec 08, 2007 2:05 pm    Post subject:
Reply with quote

-818
Timestamp mismatch error.

Read the manual for details.
Back to top
View user's profile Send private message
vicky10001
Warnings : 1

Active User


Joined: 13 Jul 2005
Posts: 136

PostPosted: Sat Dec 08, 2007 2:07 pm    Post subject:
Reply with quote

-818
-818 THE PRECOMPILER-GENERATED TIMESTAMP x IN THE LOAD MODULE IS
DIFFERENT FROM THE BIND TIMESTAMP y BUILT FROM THE DBRM z

Explanation: The SQL precompiler places timestamp 'y' in the DBRM, and
time stamp 'x' in the parameter list in the application program for each
SQL statement. At BIND time, DB2 stores the DBRM timestamp for run-time
use. At run-time, timestamp 'x', for the SQL statement being processed, is
compared with timestamp 'y' derived from the DBRM 'z' at BIND time. If the
two timestamps do not match, the DBRM and the application program were not
the result of the same precompile.

This problem can occur if you:

o Precompile, compile, and link, without doing a BIND of the
application,
o Precompile and BIND, without doing the compile and link for the
application program, or
o BIND the application using a DBRM that resulted from a different
precompile of the application program than that which produced the
object module that is linked into the application module.

The timestamps 'x' and 'y' are DB2 internal timestamps. They do not have
an external interpretation.

System Action: The statement cannot be executed.

Programmer Response: BIND the application again, using the DBRM for the
application program that matches the object module.
Back to top
View user's profile Send private message
sabyasachi

New User


Joined: 31 Aug 2006
Posts: 3

PostPosted: Sat Dec 08, 2007 11:49 pm    Post subject: -818
Reply with quote

ok, the reply is well n good.
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 -> ABENDS & Debugging All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts DB2: How to solve -805 DB2 Sql code trushant.w Mainframe Interview Questions 3 Fri Oct 04, 2013 3:47 pm
No new posts how to solve -904 in cobol db2 program. Escapa DB2 3 Tue Jul 19, 2011 5:34 pm
No new posts Solve file status code 46 Robert Sample COBOL Programming 20 Tue May 04, 2010 4:07 pm
No new posts CSKL:EZY1295E BIND CALL FAILURE.Pleas... tiger_wen CICS 19 Thu Feb 04, 2010 10:39 pm
No new posts How to solve tape GDG contention nemo_budd JCL & VSAM 3 Fri Nov 06, 2009 8:59 pm


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