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;