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 |
describe the job statement, its meaning,syntax and significant keywords?
What is the purpose of include statement in a JCL?
How many JOB statements a JCL can have ? If there are more than one JOB statements in a JCL, are they submitted in succession or in parallel ?
I have mainpgm(abc) this is the only cobol pgm(non-db2).And this pgm calling subpgm name "acd" this also only cobol(non- Db)and this pgm calling some other subpgm this pgm has cobol-db2 pgm. 1) IF you calling static mode how to run and how to compile? 2) IF you calling dynamic mode how to run and how to compile? plz suggestion me.
What is QSAM error usually when it is occurs?
List some valid operation codes in JCL
How to pass the temp dataset form one JOB step to another?
IN-STREAM DATA NOT ALLOWED IN PROC how can come out from this problem
When you specify multiple datasets in a JOBLIB or STEPLIB, what factor determines the order?
State the uses of syspring, sysin, sort fields, sum fields and dummy.
What is meant by S0C7 system abend code?
A chkpt is the parameter coded for multi-volume qsam datasets in a dd statement. When a chkpt is coded as chkpt=eov, a checkpoint is written to the dataset specified in the sysckeov statement at the end of each volume of the input/output multi-volume dataset. State whether true or false?