![]() |
SQL-J Language Reference
|
Reference Manual |
AT ISOLATION clauseAllows a user to specify an isolation level for a SELECT statement without committing the current transaction. This clause changes the isolation level for the current statement only, not the transaction. The other ways of changing the isolation level for a connection, JDBC method calls and the SET TRANSACTION ISOLATION LEVEL statement, commit the current transaction. For information about isolation levels, see Locking, Concurrency, and Isolation in the Cloudscape Developer's Guide. NEW: Support for REPEATABLE_READ is new in Version 3.6. Syntax
AT ISOLATION { AT ISOLATION clause Examples
-- set the isolation level to SERIALIZABLE for this |
|
![]() Cloudscape Version 3.6 For information about Cloudscape technical support, go to: www.cloudscape.com/support/.Copyright © 1998, 1999, 2000 Informix Software, Inc. All rights reserved. |