What does the sqlcode of -818 pertain to?
Answers were Sorted based on User's Feedback
Answer / srinivasa yadav
MISMATCH OF TIME STAMP TOKEN OF LOAD MODULE AND PLAN.
Is This Answer Correct ? | 3 Yes | 0 No |
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 |
What is database reorganization?
What is Declaration Generator(DCLGEN)?
Give the COBOL definition of a VARCHAR field.
When one binds a PACKAGE ( of a plan ) what package information is stored and where it is stored?
where can we use index and subscript ? with example ?
Suppose there are many duplicate records in a Db2 table. What is the query to retrive only duplicate records?
What is buffer pool?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
What is db2? Explain.
How does the processing of a correlated subquery differ from a non correlated subquery?
Explain about rct.
What is a SELECT statement?