Transactions handling

Informix® and Microsoft™ SQL SERVER handle transactions in a similar manner.

Informix native mode (non ANSI):

Microsoft SQL SERVER supports named and nested transactions:

Transactions in stored procedures: avoid using transactions in stored procedure to allow the client applications to handle transactions, according to the transaction model.

Solution

Informix transaction handling commands are automatically converted to Microsoft SQL SERVER instructions to start, validate or cancel transactions.

Regarding the transaction control instructions, the BDL applications do not have to be modified in order to work with Microsoft SQL SERVER.

Important: If you want to use savepoints, do not use the UNIQUE keyword in the savepoint declaration, always specify the savepoint name in ROLLBACK TO SAVEPOINT, and do not drop savepoints with RELEASE SAVEPOINT.