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 database reorganization?

0 Answers  


What is Declaration Generator(DCLGEN)?

1 Answers  


Give the COBOL definition of a VARCHAR field.

2 Answers  


When one binds a PACKAGE ( of a plan ) what package information is stored and where it is stored?

3 Answers  


where can we use index and subscript ? with example ?

3 Answers   CTS,






Suppose there are many duplicate records in a Db2 table. What is the query to retrive only duplicate records?

4 Answers  


What is buffer pool?

0 Answers  


What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

0 Answers  


What is db2? Explain.

0 Answers  


How does the processing of a correlated subquery differ from a non correlated subquery?

1 Answers  


Explain about rct.

0 Answers  


What is a SELECT statement?

1 Answers  


Categories