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 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