X/Open DTP versus traditional Sybase transaction processing  Transaction management

Chapter 4: Application Programming Guidelines

Transaction and connection management

Applications must pay special attention to commands related to:

NoteThe XA Interface uses an ANSI default isolation level of 3. To minimize read-only locking, programs can set the transaction isolation level in the XA configuration file, or they can use select xxx from table noholdlock in individual SQL operations. See the Transact-SQL User’s Guide for additional information on transaction isolation levels.





Copyright © 2005. Sybase Inc. All rights reserved. Transaction management

View this book as PDF