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
How to handle duplicate error handling in RPG?
What is file identifier where we can use?
how can you display specific subfile page on the screen in unequal subfile?
What is the diff bw PF/LF Name and their Record format name? what is restriction in record format then file name?
1.Load an runtime array of length 99 from the pf and you want to handle all the possible errors?
What is difference between bind by copy and bind by reference?
what is the difference between do while and do until?
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...........
what is the necessary keyword needed to scroll subfile records?
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.
is this a rpg channel?
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...
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.
How to declare the pull button in AS/400..
what is a rpg?