create a temp file and manipulate data all in ILE

[Guest.Visitor]

Now you can do it all in RPG and SQL, no more limitation of CL scenario, you need to copy a subset of records from production file and then manipulate the data (e.g. change the key fields) and then copy the data back into production file. A good method to duplicate records but change the key values.