Transactions handling

Informix® and Sybase ASE handle transactions in a similar manner.

Informix native mode (non ANSI):

Sybase ASE:

Solution

Informix transaction handling commands are automatically converted to Sybase ASE instructions to start, commit or rollback transactions.

Make sure that the database uses the default unchained mode (set chained off) and allows DDLs in transactions ('ddl in tran' option is true).

Regarding the transaction control instructions, the BDL applications do not have to be modified in order to work with Sybase ASE.