Transaction savepoints

Using transaction savepoints with different database engines.

IBM® Informix® IDS 11.50 introduced transaction savepoints, following the ANSI SQL standards. While most recent database severs support savepoints, you must pay attention and avoid Informix specific features. For example, Oracle® (11), SQL Server (2008 R2), SAP® ASE (15.5) do not support the RELEASE SAVEPOINT instruction. The UNIQUE clause of SAVEPOINT is only supported by IBM Informix and IBM DB2® LUW.

Table 1. Transaction savepoint intructions by database server brand
Database Server Type SAVEPOINT & ROLLBACK WORK TO SAVEPOINT RELEASE SAVEPOINT SAVEPOINT UNIQUE Related topic
IBM DB2 LUW Yes Yes Yes See details
IBM Informix Yes Yes Yes See details
IBM Netezza® No No No See details
Microsoft™ SQL Server (Only 2005+ with SNC driver) Yes No No See details
Oracle MySQL / MariadDB Yes Yes No See details
Oracle Database Server Yes No No See details
PostgreSQL Yes Yes No See details
SAP ASE Yes No No See details
SAP HANA® No No No See details
SQLite Yes Yes No See details