Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

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

1 Answers  


how you will the direct the data to spool using sysout option?

0 Answers   IBM,


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.

2 Answers  


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?.

1 Answers  


What parameters can be used to limit the number of records written to a sysout dataset?

1 Answers  


If Region=0k means What Happen?

2 Answers   IBM,


Must tape dataset definitions include vol=ser specifications?

0 Answers  


what is symbolic parameters in jcl, what is a temparary data set ? where do u use ?

2 Answers   Verizon,


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.

1 Answers   HSBC,


wht r different types of sorts ?

1 Answers   L&T,


diff bw SB37,SD37,SE37 ?( bcz these 3 belongs Space related abends only)

4 Answers   RBS,


i have 10 steps in jcl program but i have to exicute only 2,4,6,8th and 10th ?how it's possible?

10 Answers   IBM,


Categories