Changing the transaction mode

You can change the transaction mode from its default of auto-commit to manual commit.

About this task

To change the transaction mode to manual commit:

Procedure

  1. Enable transaction logging for your database server.

    For information about transaction logging, see your Informix® Administrator's Guide.

  2. Call SQLSetConnectOption() with SQL_AUTOCOMMIT set to SQL_AUTOCOMMIT_OFF.