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
- 20580 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 |
in rpg could u please tell me errors types and meanings like 3030 that ....
Im traying to get out put of this below mention simple logic code.But im geting out of different.(im trying with my laptop trhough my company server. DCL &FIELD1 *CHAR 10 VALUE('TCS AS/400') DCL &FIELD2 *CHAR 10 CHGVAR(%SST(&FIELD2 1 10))(%SST(&FIELD1 10 1) Can you tell me the value of field2 after excuted of CHGVAR command.
can we perform CHAIN operation on Subfile record format....?
i want to retrieve record b/w 2 dates in as400
As Packed veriable store 2 digits in 1 byte and ZONE variable store 1 digit in 1 byte... Please tell me when we have to use Packed and Zone variable...?
i have 6 char field in program, but this field is using in all files i want to chage field size as 10 char , how can i do this except using *like defn...?
How do you code file / field renames in ILE RPG?
How to declare the more than one file in cl/400.
what is the rpg system?
Program to read marks of 10 students for 4 subjects and compute and display total marks and status of each student in rpg
1.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? 2. Assume my file has 100 records and I want to see only first 10 records. Is this possible through LF? 3.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? 4.What is difference between Bind by copy and bind by reference?
Suppose we have 10 records with same name and we are reading using READE,after 4 record i have to use CHAIN what is the output
RPG400 
