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 |
consider the following progrm statements MOVE 0 TO SW.NO.OF.REC PERFORM PRI-OUT UNTIL SW=1 DISPALY NO.OF.REC STOP RUN PRE-OUT READ IN-FILE AT END MOVE 1 TO SW WRITE OUO-REC FROM IN-REC ADD 1 TO NO.OF REC if the IN-FILE contains 1000 records what value will be displayed after the PERFORM is over? assume that N0.OF.REC has PIC 9(4) a.1000 b.1001 c.1 d.none of the above
how you will the direct the data to spool using sysout option?
Please go thru the below points and let me know how to code this. 1. Sort the input dataset for the condition : Starting position is 37,length of the field is 13 based on character and in the ascending order , starting from position 25 length of 12 ,character and in the ascending order. Use a temporary dataset to hold the sorted file. 2. Use the temporary file created in the above step as the input for the next step. The next step is to execute a program and produce an output file. Use the temporary file created in the above as work file 1 and the output of the file to be created in this step work file 2.Also, pass a parameter to the program that is to be executed in this step. The parameter should have the current date in YYYYMMDD format. For the sake of convenience, you can use the below Job Name : Sample1 Input DSN : PCABDT11.CABD.TEST.INPUT Temporary DSN : Sort1 Output DSN : PCABDT11.CABD.TEST.OUTPUT Program Name : SAMPLE Thanks in Advance for your response.
I HAVE A SEQUENTIAL FILE CONTAINING ONE RECORD IN WHICH I HAVE ONE FIELD AS CUSTOMER IDENTITY NUMBER FIELD WHICH IS A SIGNED FIELD. HOW TO SEQUENTIALLY INCREMENT THIS FIELD USING OVERLAY PARAMETER?.
What parameters can be used to limit the number of records written to a sysout dataset?
If Region=0k means What Happen?
Must tape dataset definitions include vol=ser specifications?
what is symbolic parameters in jcl, what is a temparary data set ? where do u use ?
How different is the JCL executing a COBOL program? 1) if the program is using VB file as input. 2) if the program is using FB file as input.
wht r different types of sorts ?
diff bw SB37,SD37,SE37 ?( bcz these 3 belongs Space related abends only)
i have 10 steps in jcl program but i have to exicute only 2,4,6,8th and 10th ?how it's possible?