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

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.