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
- 20924 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 |
I have one cl program which calls two rpg programs named a & b. I am loading a run time array in Pgm A and the control comes back to cl pgm. i call pgmb and I want to read the runtime array in pgmb which was loaded in pgma. How it can be acheived. I should not use any intermediate file or dataarea to store the loaded values.
1.How to read a subfile in out put mode? 2.what are the keywords used to share same file? 3.using composite key which rpg code used?
Is it possible to call a subfile using CL. IF yes.. kindly help me out with explanation...?
how do I declare a minor?
How can we know running job is batch or interactive?
how to change the length of the field in a physicalfile?
What is the difference Return and InLr?
How I can reread the physical file in CL program once the end of file reached in same CL program.
Can anybody tell me the setps to create .csv file in IFS folder on AS/400. I also need to know how I can send this .csv file to PC in xls sheet.....?
what is the use of sflnxtchg?
How to update selected fields from pf without using update opcode. How to read all member in Rpg-3,without using any cl command?
1..Write an sql query to find the employee name who is having 2 phone numebr? 2.Write an sql query to the the second highest salary of the employee?
RPG400 
