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