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 -Dsrv AUTOCOMMIT,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.