The default Informix database transaction isolation must be Committed Read. It cannot be Uncommitted Read or Transactions not supported.
This is ANSI standard behavior that guarantees that user2 will see the data only after user1 has committed the changes. If a change is in progress, user2 will be locked out until the change is either committed or rolled back. This is only possible if the database is logged.
Copyright © 2005. Sybase Inc. All rights reserved. |
![]() |