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



How does -818 sql error occur? Why does it happen and what can be done to overcome this error code..

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

How does -818 sql error occur? Why does it happen and what can be done to overcome this error code..

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

How does -818 sql error occur? Why does it happen and what can be done to overcome this error code..

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

How does -818 sql error occur? Why does it happen and what can be done to overcome this error code..

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

How does -818 sql error occur? Why does it happen and what can be done to overcome this error code..

Answer / guest

817

Is This Answer Correct ?    0 Yes 3 No

Post New Answer

More JCL Interview Questions

describe the job statement, its meaning,syntax and significant keywords?

1 Answers  


What is the purpose of include statement in a JCL?

2 Answers  


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 ?

4 Answers   IBM, Tech Mahindra,


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.

0 Answers   HP,


What is QSAM error usually when it is occurs?

1 Answers  






List some valid operation codes in JCL

3 Answers  


How to pass the temp dataset form one JOB step to another?

6 Answers   IBM,


IN-STREAM DATA NOT ALLOWED IN PROC how can come out from this problem

7 Answers  


When you specify multiple datasets in a JOBLIB or STEPLIB, what factor determines the order?

0 Answers  


State the uses of syspring, sysin, sort fields, sum fields and dummy.

0 Answers  


What is meant by S0C7 system abend code?

8 Answers  


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?

0 Answers   IBM,


Categories