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 |
Hi guys. Im in AS/400(RPGLE,CLP) from last 1 year.Now i wan to upgrade my Knowledge in AS/400. Suggest me some new fields & courses which falls under AS/400. Waiting for your quick Response.
How would display prime numbers using CL program?
What is the diff bw PF/LF Name and their Record format name? what is restriction in record format then file name?
i)What is the command to lock a file in a program ii)2. Can you get a level check error in a CL program
How can a screen field that has changed since the last output operation be detected?
How can we make use of SETLL operation in CL?
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.....?
Please tell me how to read the records from a file with load an array of size with error conditions(The logic answer for this question is ARR is array of 99 elements Z-ADD 0 IDX *LOVAL SETLL FILE READ FILE 99 *IN99 DOWEQ *OFF IDX ANDLT 99 ADD 1 IDX MOVE FIELD ARR,IDX READ FILE 99 ENDDO).So,Please give me the complete of this code.
What is the difference between copybooks and subprocedures in as400?
what is post opcode do
Write a program to display prime numbers between 1 to 100 using RPGLE.
what is EXCEPT command in rpg and use