Background... I use OCL and SQLRPG. I am having an issue after I have built a file of records from my Select. This file contains duplicates that I need to remove. I have a EXEC SQL DELETE clause in the RPG after my "DO" loop ends. The command does nothing, however, when I drop the command into a 400 sQL session, she runs great. Please advise...
Here is the snippet
/free endif; enddo; exec sql close ahpl1c1; exec sql Delete from ahpl F1 where RRN(f1) > (select MIN(RRN(F2)) from ahpl F2 where F2.f00001 = F1.f00001); *inlr = *on; /end-free
May 4, 2010 2:06 PM
May 6, 2010 6:27 PM