Consider the following:
If DirectConnect is configured for long transactions, the SQL submitted must not be sensitive to a commit. In other words, if the SQL is an insert statement that does not batch a commit into the statement, the insert rolls back using long transaction rules.
If the DB2 access service is configured for short transactions, the SQL submitted is bound by short transactions, which supply a commit by default.
Copyright © 2005. Sybase Inc. All rights reserved. |