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
- 32667 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
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?
What is the difference between iter and do?
do you use message subfiles? What are the necessary keywords required coding a message subfile?
what is *place and *auto keyword in prtf ?plz explain
how can you display specific subfile page on the screen in unequal subfile?
how do I declare a minor?
what is an online rpg?
how do you use commitment control in rpg?
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?
Explain mdt?
what are the key words you must use when using a subfile?
what happens when sflsiz = sflpag? What are the advantages and disadvantages?
which program rpg or cl is efficent to update a transaction onto a database file and why ?
When we have a file with Duplicate records and I want to read the unique record from the file. For example a file containing Emp Name as 'Ram' and there are 3 entries of it. So how to read a unique record from File?
