ALLBASE/SQL Reference Manual (36216-90216)

538 Chapter12
SQL Statements S - Z
SET SESSION
checking mode is reset to IMMEDIATE or the current transaction ends.
IMMEDIATE specifies that constraint errors are checked when a statement executes.
This is the default.
STATEMENT specifies that error checking occurs at the statement level. This is the
default.
ROW specifies that error checking occurs at the row level.
QUERY sets the action for timeouts or deadlocks to rollback the statement or
query.
TRANSACTION sets the action for timeouts or deadlocks to rollback the transaction.
DEFAULT specifies to use the default timeout duration for the DBE specified in the
START DBE statement.
MAXIMUM specifies to use the maximum timeout duration for the DBE specified in
the START DBE statement.
TimeoutValue specifies the timeout duration to use in seconds or minutes.
:HostVariable4 is an integer host variable specifying the timeout duration to use in
seconds or minutes.
SESSION specifies self-termination at the session level, and allows external
termination at the session level only.
TRANSACTION specifies self-termination at the transaction level, and allows external
termination at the session or transaction level.
QUERY specifies self-termination at the query level, and allows external
termination at the session, transaction, or query level.
RESTRICTED specifies no self-termination, and allows external termination at the
session level only. This is the default.
FILL is used to optimize I/O performance when loading data and creating
indexes.
PARALLEL FILL is used to optimize I/O performance for multiple, concurrent loads to the
same table. The PARALLEL FILL option must be in effect for each load.
NO FILL turns off the FILL or PARALLEL FILL option for the duration of the
session. This is the default fill option.
Description
• Detailed information about isolation levels is presented in the "Concurrency Control
through Locks and Isolation Levels" chapter.
• You can issue the SET SESSION statement at any point in an application or ISQL
session. Whether issued within or outside of a transaction, the attributes specified in a
SET SESSION statement apply to the next and subsequent transactions.
• Any attribute specified in a SET SESSION statement remains in effect until the session
terminates unless reset by another statement. See the "Using ALLBASE/SQL" chapter,
"Scoping of Transaction and Session Attributes" section for information about