RE: RPGLE I/O opcodes with commit/rollback

John,

This is possible and in fact very easy to do. Here is a quick synopsis:

1. Make sure the files are journaled.
2. In a CL, STRCMTCTL before calling your RPG program (or opening the file).
3. Put the COMMIT keyword on the file spec of the file you want to use commitment control on.
4. Use the COMMIT and ROLBK opcodes in your RPG program to commit or rollback any database I/O.

Here is an article to help you out. http://www.mcpressonline.com/rpg/update-your-data-with-peace-of-mind-using-commitment-control.html



Brian May
Solutions Architect
Profound Logic Software
http://www.profoundlogic.com
937-439-7925 Phone
877-224-7768 Toll Free
  

The IBM i Modernization Experts
www.profoundlogic.com
             


-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of John R. Smith, Jr.
Sent: Wednesday, November 18, 2015 1:40 PM
To: RPG programming on the IBM i (AS/400 and iSeries) <rpg400-l@xxxxxxxxxxxx>
Subject: RPGLE I/O opcodes with commit/rollback

I got into a heated conversation today about using the write / update / delete opcodes (not embedded SQL) and doing commits / rollbacks. I said it could not be done but the other guy said he has done it. He said he wrote RPG code that did opcode writes and updates (again, not via SQL) and was able to do rollbacks to remove the data from the write / update.



Does anyone know of any way of doing this?

--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at http://archive.midrange.com/rpg400-l.