1)how to do date validation in rpg?
2)how to delete dUPLICATE RECORDS?

Answer Posted / raghav

1. TESTD

2. Delete from File1 F1 where RRN(f1) > (select MIN(RRN(F2)) from File1 F2 where F2.Field1 = F1.Field1)

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is difference between bind by copy and bind by reference?

1741


Program to read marks of 10 students for 4 subjects and compute and display total marks and status of each student in rpg

729


Suppose we have one database file and it is used by 5 programs and in 3 program we have to add some records in datbase file s what is the impact on other program?

1463


what was the robotech rpg?

691


What is the diff bw PF/LF Name and their Record format name? what is restriction in record format then file name?

2528






how do I declare a minor?

724


do you use message subfiles? What are the necessary keywords required coding a message subfile?

698


1.Load an runtime array of length 99 from the pf and you want to handle all the possible errors?

2380


How many program bind in one module....

2134


how can I tell when to replace the array?

712


what is the rpg system?

676


What is a record lock error?

1280


How to declare the pull button in AS/400..

1889


Explain mdt?

672


can you debug ile rpg program using isdb?

748