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 the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.
What is a recovery log?
I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,which cost is second maximum in the table?
What is sqlcode -922 ?
Give the COBOL definition of a VARCHAR field.
Explain package in db2 and its advantages?
what is check point and restart Logic ? why do we go for that ??
what is the name of the default db2 catalog database?
How many databases are there?
How to know the primary key of a table without defining the primary key in the table?
what are the copybook changes generally we done?can anyone tell me......... Thanks in advance........
where will u check for sqlcode ?