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
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!