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 does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
how to u check the query is executing or not ?where will u check for sqlcode ?
what will be the output of the below given query, if no matching records are found : (a.) 0 (b.) null (c.) error select Avg(salary) from TableA where Deptno = 'insurance'
Why might full image copies be faster to implement than an incremental image copy?
What is the difference between group by and order by?
How we create a tables in db2,what is the process/syntax to create a table with example plz?
What is the difference between IN subselects and EXISTS subselect?
How to execute stored procedure in db2 command editor?
What are the 4 environments which can access DB2 ?
what is differnece between DROP TABLE & DELETE TABLE .
In my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)