What does the sqlcode of -818 pertain to?

Answers were Sorted based on User's Feedback



What does the sqlcode of -818 pertain to?..

Answer / srinivasa yadav

MISMATCH OF TIME STAMP TOKEN OF LOAD MODULE AND PLAN.

Is This Answer Correct ?    3 Yes 0 No

What does the sqlcode of -818 pertain to?..

Answer / deepa

Time stamp mismatch.

Is This Answer Correct ?    2 Yes 0 No

What does the sqlcode of -818 pertain to?..

Answer / s

When the application goes through precompile, compile and
link-edit phase and the bind plan is not done. Because when
you precompile a pgm, a new consistency token is placed in
modified source code and the DBRM but if you dont bind the
plan, the dbrm/package with that consistency token will not
be found. Hence the error message -818.

Is This Answer Correct ?    1 Yes 3 No

Post New Answer

More DB2 Interview Questions

What is reorg in database?

1 Answers  


I have a table name Table1 which contain columns Cust_no, car_model, country, salesamt. The records are 101, Fiat, India, 12345 2nd record is 102, Tata, USA, 98743 3rd record is 101, indica, India, 65342 4th record is 103, Toyota, UK, 64522 5th record is 103, Maruti, USA, 98632 and so on..... Now my question is write sql query which will give me detail about the sum of sales amount in perticular country

2 Answers   IBM,


Parm value passed is PARM=(10,20). how do code linkage section and how would you add these two passes values and show result in cobol program.

3 Answers   IBM,


What is host variable?

0 Answers  


is there any restrictions for unions ?

4 Answers   Patni,






What is blu acceleration in db2?

0 Answers  


What is the information associated with sysibm.syslinks table?

0 Answers  


What is a LIKE table and how is it created?

2 Answers  


Hi this is sures. i need to practice the ibm mainframes.could u telme how can i get userid from IBM.how much cost they will collect for one user id.can send me the details please.thanq

2 Answers  


In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.

5 Answers   CTS,


How do I add a column to an existing table in db2?

0 Answers  


What kind of database is db2?

0 Answers  


Categories