Sample Header Ad - 728x90

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