Neoview SQL Reference Manual (R2.4)

Syntax Description of SET TRANSACTION
transaction mode
specifies the attributes that you can set. You cannot specify any of the options—isolation
level, access mode, size of the diagnostics area, or autocommit—more than once within one
SET TRANSACTION statement. You cannot use the AUTOCOMMIT option with any other
option.
isolation-level
specifies the level of data consistency defined for the transaction and the degree of
concurrency the transaction has with other transactions that use the same data. The default
isolation level is READ COMMITTED.
access-mode
specifies the type of data access that the transaction requires, depending on whether the
transaction changes the database.
If the isolation-level is READ UNCOMMITTED, you cannot specify READ WRITE.
The default access-mode is READ WRITE.
See “Transaction Access Modes” (page 33).
diagnostics-size
specifies the size of the diagnostics area (as an estimate of the number of expected
conditions) used to return SQL query completion and exception condition information.
number-of-conditions is an exact numeric literal with zero scale. If the
diagnostics-size is not set, it defaults to a system-defined value.
autocommit-option
specifies whether Neoview SQL commits or rolls back automatically at the end of statement
execution. This option applies to any statement for which the system initiates a transaction.
If this option is set to ON, Neoview SQL automatically commits any changes or rolls back
any changes made to the database at the end of statement execution. AUTOCOMMIT is
on by default at the start of a session.
If this option is set to OFF, the current transaction remains active until the end of the
session unless you explicitly commit or rollback the transaction. AUTOCOMMIT is a
Neoview SQL extension; you cannot use in it with any other option.
Using the AUTOCOMMIT option in a SET TRANSACTION statement does not reset
other transaction attributes that may have been specified in a previous SET
TRANSACTION statement. Similarly, a SET TRANSACTION statement that does not
specify the AUTOCOMMIT attribute does not reset this attribute.
norollback-option
specifies that a transaction does not rollback if it aborts. All changes made to the database
as part of the failed transaction, up to the point of failure, are persistent.
autoabort-interval
controls the autoabort feature.
timeout
specifies the transaction is aborted automatically when it reaches the duration
indicated. Timeout can be specified in hours, minutes, and seconds.
The minimum value for an integer is 20 seconds. The maximum values are 21474836
seconds, 357913 minutes, or 5965 hours. If the timeout value does not satisfy the
conditions, an error message is generated.
0
Turns off the autoabort function for this transaction, eliminating any time limit.
188 SQL Statements