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 |
On the create tablespace, what does the CLOSE parameter do?
What is query_cache_limit?
What is a dbrm in db2?
Shall i use this query to retrieve first 4 records, Select empno, sal from emptbl where empno < 5. like this can we fetch first 100 records?
define clustering index.
What is the function of logging in the db2 database?
Where can you declare a cursor in a cobol-db2 program?
When the like statement is used?
Explain about open switch business continuity software?
How to solved 818 error
4 Answers Keane India Ltd, Wipro,
Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?
Do we need cursor for Count(*)?