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 a collection?
What is the use of db2 optimizer?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?
Once you create a view, where would information about the view be stored?
What is database reorganization?
What are the various locks available?
What is host variable in db2 cobol?
Is DECLARE TABLE in DCLGEN necessary? Why it used?
what is db2 restart?
What is a clustering index ?
What is a subselect? Is it different from a nested select?