How does -818 sql error occur? Why does it happen and what
can be done to overcome this error code?
Answers were Sorted based on User's Feedback
Answer / swetha
IT is a TIMESTAMP error..
When loadmodule and plan are out of sync then this error'l
be occures.
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / vinay sonar
-818 means there is mismatch between timestamp of plan and
timestamp of loadmudule of COBOL program in precompilation
process
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / somalaraju
do the Precompilation again to overcome Timestamp mismatch(-818 error),bcz Timestamp is allocated at Precompilation time only.
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / goud
-818: precompiler generated timestamps mismatch between the load module and plan
Resolution: do fresh rebind
| Is This Answer Correct ? | 1 Yes | 0 No |
What do you know about jcl?
how can handle the s0c4 abend???
How do you designate a comment in JCL?
How do you submit a job for execution?
In a proc i will concatinate 4 dd statements.i want to overide 3 dd statement through jcl how?
Explain about LMQUERY�give a dialog information about a data set
What does a disposition of (MOD,DELETE,DELETE) mean ?
What are the differences between JES2 & JES3 ?
How to execute step2,step1,step3 when step1,2&3 are in order
what is the difference between perform varying and perform
Can we have a JOBSTEP without any EXEC ?
I want to JCL sort for Non-COMP and COMP-3 fields SORT FIELDS=(1,5,A,6,11,A,12,11,A,19,1,A,20,1,A),FORMAT=BI,EQUALS Length of comp bytes is 11 bytes which start at 6byte and 12 byte considering 11 bytes in comp-3 is 6 bytes. Can anyone tell if the above sort work SORT FIELDS=(1,5,A,6,6,A,12,6,A,19,1,A,20,1,A),FORMAT=BI,EQUALS does not works OK