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 |
How to resolve -917 sql code in DB2?
I am getting a error multiple row fetched while executing a Cobol-DB2 program.How can I solve it without using a cursor.
Which transaction use a command thread ?
What language is db2 written in?
What is reorg in database?
If I have 5 Queries in a DB2 Cobol program , while precompiling how many DBRMs will get created and How many Plans and Packages will get created while Bind Process?
What is a view? Why use it?
When is the results table for the query in a DECLARE CURSOR statement created?
Give some example of statistics collected during RUNSTATS?
What happens in bind step in a db2 program?
in column y record abc.v abc.s xyz.j abc.h i wan only abc columns how to retrieve thi records
is there any restrictions for unions ?