Job is in MSGW while reading the input file and writing a
new record / updating a reacod due to Duplicate data error.
What action would you take ( C D I R )...?
Answers were Sorted based on User's Feedback
Answer / selvam
take dump option(D) and delete the duplicate record and
retry the job.
| Is This Answer Correct ? | 10 Yes | 0 No |
Answer / sudhir
Hi...You can give an 'I' and the job will continue
processing the next records..Note that this will not update
the record..
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / ravi
If a driver CL is there for the RPG, then take a 'C' on RPG, so that lock will be released. Take the RRN of the file using JOB log before cancelling the RPG. Check the record and delete it. Then take a 'R' on CL. Job will run fine.
You can also take an I if you do not want to write it again.
| Is This Answer Correct ? | 2 Yes | 0 No |
Some time you cant able to delete a duplicate record cause
this MSGW may lock that file so in this case you can give I
- ignore, so that record wont get lock,in the mean time imly
try to delete the duplicate records in second session. And
than now give Retrive - 'R'
| Is This Answer Correct ? | 0 Yes | 3 No |
Can we have a Physical file without any member ? Please let me know
how can we find setll setgt chain read reade readp operations are successfull or not,give example.explain in detail.
How to read a record from file where there is multiple record occurrence is available?
How to handle duplicate error handling in RPG?
Suppose i am having 3 programs PgmA,pgmB,pgmC and using source debugger. At debugging time i found that pgmC having some code error..then in debug mode directly how can i debug pgmC
Can you copy the records created by the OPNQRYF to other files and how?
Hi Viewers can any body explain me how to update and ahange the already existed data in physical file using subfile ? please explain me with the code if possible?
Difference between RESET and CLEAR
how to retrieve RRN value in RPGLE program
A particular job executing on the iS is not behaving as expected and is operating in an environment in which it can be debugged. What commands would you use to debug and observe the program?
Hi friends, I am using a load all subfile , and currently i am in in the third page of the subfile , from third page i have selected a record and called some other program .on returning, subfile is being loaded from the frist page. so can any one kindly suggest me in retaining my third page after returning. i.e loading from third page.
what is importance of 'MAPFLD' IN OPNQRYF FILE ?