Some data sources (for example, Sybase) support transactions with a degree of granularity that might cause error conditions when executing complex transactions. For example, a transaction might be rolled back unsuccessfully.
Avoid using the data-source transaction manager in such cases. Instead, specify -DsrvAUTOCOMMIT,1 to use the OpenEdge client's local before-image mechanism to connect to the data source. This startup parameter creates a transaction from each SQL statement that the DataServer issues. OpenEdge emulates the logical transaction on behalf of the application using the local before-image mechanism. This connection technique is useful in multi-database applications.
Note: OpenEdge does not guarantee crash recovery when it uses the local before-image mechanism to emulate transactions. The Sybase ODBC drivers require -DsrvAUTOCOMMIT,1.