I have to create a command that permits a user to copy records from one file to another and then remove those records from the first file.
We've been doing it all manually using CPYF and INCREL and then deleting the records using an SQL Delete statement.
I got the idea to create a command and put it all in a CL CPP but is it possible to use the Delete SQL statement in a CL?
I went through the Embedded SQL Programming book but it only talks about C, C++ and other languages, all I know is CLP, RPG and a little RPGLE.
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!