Changing the transaction mode

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

To change the transaction mode to manual commit:

  1. Enable transaction logging for your database server.

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

  2. Call SQLSetConnectOption() with SQL_AUTOCOMMIT set to SQL_AUTOCOMMIT_OFF.
Parent topic: Transaction processing
Copyright© 2020 HCL Technologies Limited