SQLAnywhere: Savepoint for ROLLBACK not found
1
vote
1
answer
477
views
What is the correct way on setting and rolling back to savepoint on SQLAnywhere. Having this snippet:
begin transaction;
SAVEPOINT spt_abc;
insert into eins (pl1) values (5);
SAVEPOINT spt_123;
UPDATE eins SET pl1 = 10 where pl1 = 5;
ROLLBACK TO SAVEPOINT spt_abc;
commit;
Getting this error message while running it in dbisql:
> Could not execute statement. Savepoint 'spt_abc' not found SQLCODE=-220, ODBC 3 State="HY000" Line 6, column 1 You can continue
> executing or stop.
>
> ROLLBACK TO SAVEPOINT spt_abc
the very same happens when trying to rollback to spt_123.
Asked by frlan
(495 rep)
Aug 28, 2015, 12:50 PM
Last activity: Aug 30, 2015, 07:41 PM
Last activity: Aug 30, 2015, 07:41 PM