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) do not support the RELEASE
SAVEPOINT instruction.
| Database Server Type | SAVEPOINT & ROLLBACK WORK TO SAVEPOINT | RELEASE SAVEPOINT | SAVEPOINT UNIQUE | Related topic |
|---|---|---|---|---|
| IBM Informix | Yes | Yes | Yes | 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 HANA® | No | No | No | See details |
| SQLite | Yes | Yes | No | See details |
| Dameng® | Yes | No | No | See details |