Interested to Buy Any Domain ? << Click Here >> for more details...
1)how to do date validation in rpg?
2)how to delete dUPLICATE RECORDS?
- 12 Answers
- 33220 Views
- IBM, Opus, I also Faced
- E-Mail Answers
Answer Posted / madhusudhan
1. Date Validation you can do with TESTD
2. Duplicate Records. There are two ways to delete this
a. Through SQL, after selecting the RRN numbers, you can
use the delete statement in SQL to delete the unwanted
record based on the RRN
b. Through RPG, but if you use the SETLL and READE, all
the records along with the duplicates will get deleted , so
you need to use one variable for count, once it reaches 1 ,
stop doing the delete.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
what is the necessary keyword needed to scroll subfile records?
what is the difference between do while and do until?
How to call one program from another program in RPG? please help me with the code
What is ment by record level identifier?
What is the difference between copybooks and subprocedures in as400?
We have job which is running as batch. It takes atleast 06 hours to complete tht job. But I wanna do tht job with in 3 hours?
What is the purpose of record level identifier?
which program rpg or cl is efficent to update a transaction onto a database file and why ?
How can we override a file during runtime in rpg?
how do I play {insert rpg system here}?
How do u design a physical file, when you have 2 Unique fields like for eg in A student file student ID and student examination no both are unique
is this a rpg channel?
What is the diff bw PF/LF Name and their Record format name? what is restriction in record format then file name?
how do I declare a table or array in rpg iv?
Assume 2 users are using the same file and first user updates some record in the file. Will the 2nd user will be able to see the updated record or not?
