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 |
Is db2 a programming language?
What is index in db2?
Where is the output of EXPLAIN stored?
What are the various data types available in db2?
wht happens if we close cursor with cursor with hold option?
Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.
What is database reorganization?
what is a trigger and types of triggers
When do you specify the isolation level?
What is data manager?
For update of a row in cursors, when do we move value into host variable in cobol progrm? is it before open or before fetch ?
What is drop table?