Re: Anyway to use SAVEPOINTS in a transaction using RPG RLA?

So the SQL savepoints affect records written under commitment control
with RPG's record level access op-codes (and UPDATE)?

Hm...that could work...

I'll have to play around with that scenario.

Charles

On Sun, Dec 26, 2010 at 4:42 AM, K2R400 <patrick30.thomas@xxxxxxxxxxx> wrote:

Charles Wilt <charles.wilt@...> writes:

All,

Is the anyway to use savepoints from and RPG program using record level

access?

I'm pretty sure the answer is no, in fact I believe I saw that fact
explicitly stated somewhere...but I thought I'd double check.

I've googled some but don't see anything...

Thanks!
Charles

You have to insert a EXEC SQL statement in your program with SAVEPOINT and use
the SQL ROLLBACK statement instead of ROLBCK :
ex :

Exec SQL SAVEPOINT A ON ROLLBACK RETAIN CURSORS;
Key = 1;
Chain Key Myfile;
....
Update Format;

Exec SQL Rollback Work TO Savepoint A;




--
This is the RPG programming on the IBM i / System i (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.