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

How to handle duplicate error handling in RPG?

1680


What is file identifier where we can use?

652


how can you display specific subfile page on the screen in unequal subfile?

675


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

2519


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

2373






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

1730


what is the difference between do while and do until?

706


give an eg of ACQ-(ACQUIRE),BIT OFF,BIT ON,DEALLOC,DUMP,FEOD,FORCE,MHHZO,MHLZO,MHLLZO,MLHZO,REL,RESET,TESTZ,TESTB,TESTN----GIVE SMALL EXAMPLE TO THE OPCODES...TO UNDERSTAND FUNCTIONING...........

3286


what is the necessary keyword needed to scroll subfile records?

704


1. What is bound-by-call and bound-by-reference? 2. Where and why is *Nomain used? 3. What are the difficulties faced by programmers when using service programs? 4. Explain the different ways of parsing and compiling XML in iSeries.

5412


is this a rpg channel?

681


How to create a login screen using a command instead of display file.... intention is to get a password field on a command..... how do you achieve this...

1312


if there is a module object , how to find the program object for this module object.Assume the module object name and program object name is not same.

2199


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

1882


what is a rpg?

701