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 is alternate index?
How many instream we can write in single jcl?
How can you execute a COBOL program via SYSIN in JCL?
Explain the function of a dd statement?
if we give TIME=0 how many sec that job/step
Which statement is used to identify the private libraries in job?
what is XSUM in some fields= none, xsum ??
How do you run a COBOL batch program from a JCL? How do you run a COBOL/DB2 program?
Explain about RECORDING MODE Clause
what is the use of temporary files?
Definition of COND parameter in JCL
Can we find specific member without knowing the name of PDS or can we search a member to which PDS it belongs to? if so how?