Interested to Buy Any Domain ? << Click Here >> for more details...
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 )...?
- 4 Answers
- 20582 Views
- I also Faced
- E-Mail Answers
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 |
what is flat file?
How do you call procedures in ILE?
two attributes which govern the excecution of a job>>>>??
Suppose my file has 10 fields and I want to make the 2nd field zeros in all records. And assume I have millions of records and I dont want to read each record and update the desired field with 0. Any other way to do this in one step operation?
what is kids-rpg?
can anyone say,what is the use of operation extended H/N/P?
How to handle duplicate error handling in RPG?
How to add 2 new fields in a file? How many ways are there in as400?
How can we search particular records from the database file in RPG. For example, there are 100 records in the file.i need to retrieve all the records matching/equal to the particular 'NAME' field. How can we do the above using SEARCH criteria other than using the IF cond?
wat is curser?? and its types???
what is the difference between SETON RT & RETURN?
Suppose I have 3 jobs a b and c. I want to submit b after successful completion of a and want to submit c after successful completion of b. Without using job scheduler or job queue, how can I do that through cl program?
RPG400 
