How does -818 sql error occur? Why does it happen and what
can be done to overcome this error code?
- 5 Answers
- 13982 Views
- RBS, I also Faced
- E-Mail Answers
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 |
Explain about LMINIT - generate a data ID for a data set
what are the symbolic parameters? why do we use symbolic parameters ?
2 Answers IBM, TCS, UST, Xansa,
What are the maximum and minimum sizes of any CONTROL AREA (VSAM datasets) ?
what disp parameter we mention for creation of temporary dataset so that we can use it in later steps?
Explain about LMPUT-
diff bw vsam and normal flat file?
I have a JCL with 10 steps, want to execute first 5 steps only, what are ways of doing it?is it possible to control through JOB card?
My JCL contains four steps //STP1 A(+1), DISP = NEW //STP2 A(+2), DISP = NEW //STP3 A(+3), DISP = NEW //STP4 A(+1), DISP = OLD STP3 was abended and I want restart my JCL from STP3 onwards & what are the precaution I want to take & what are the changes I need to make. Pls let me know.
IF WE GIVE COND on step3 then, What does the following mean ? And Just adding to that, All the below COND are VALID as per the specifications. (i) COND = (8,LT,step1,step2) ---(AND/OR ?) (ii) COND = (8,LT,step1,step2, ONLY), (iii) COND = (8,LT,step1,ONLY) will it execute only if this condition is true or only if step1 ABENDS ? (iv) COND = (8,LT,step1,step2,EVEN), (v) COND = (8,LT,step1,EVEN) ?
Current version of GDG is ID.GDG.FILE.G0001V00. JCL has procedure with 2 steps like below, What will be the output file name in each step ? PROC starts Step 1 has ID.GDG.FILE(+1) Step2 has ID.GDG.FILE(+4) PEND Similarly, JCL has 2 steps in 2 separate procedure. What will be the output file names here ? PROC starts Step 1 has ID.GDG.FILE(+1) PEND PROC1 starts Step2 has ID.GDG.FILE(+4) PEND
Is it possible to define dd statements as you want?
I had 100 steps in jcl i want to execute first 10 steps only?
COBOL 
