I wrote a simple SQLRPGLE program. It accepts a "from" and "to" code, deletes all records with the "to" code, then copies all "from" records, replacing the "from" code with the "to" code.
It runs fine, produces expected results.
When I log off the session which ran the program, even hours later, it seems to add back the records which were deleted when the program ran.
I've tried changing the commitment control, but that doesn't help.
I could possibly work it out eventually, but life is hard enough! Please can someone enlighten me?
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!