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

At what stage, operator can change the class and priority of a submitted job?

2 Answers  


a dd statement has 2 types of parameters. Name them?

0 Answers  


I have a input file. Data like: ABCDEFGH.... i want out put file like AB BC CD DE....How can do this??

7 Answers   UST,


how would you create a temporary dataset? And where will you use them?

0 Answers  


what is the resolution for sb37 error

2 Answers   TCS,


jcl is like a complier....?

6 Answers  


i need some shortcuts and tso commands can any on ehelp me in these ?

1 Answers  


What is the function of the dd dcb keyword?

0 Answers  


I have a PDS and want to omit few rows of all members of a PDS. How to do it?

6 Answers   Accenture,


how to execute the last 5 steps in jcl

2 Answers   Syntel,


describe the exec statement,its meaning ,syntax and keywords?

3 Answers  


If a jcl has just 1 step and the input file to this does not exist, then what will happen if we submit this job?

3 Answers  


Categories