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?