ALLBASE/SQL Reference Manual (36216-90216)

Chapter 12 541
SQL Statements S - Z
SET SESSION
COMMIT WORK
BEGIN WORK Session isolation level CS takes effect.
.
.
.
In the above example, the new transaction started on behalf of the user after the first
COMMIT WORK has isolation level RU; cursor C1 has isolation RC; cursor C2 has isolation
level CS; and cursor C3 has isolation level RU.
Authorization
You do not need authorization to use the SET SESSION statement.
Example
The following example illustrates setting session level deferred constraint checking, DML
atomicity, and the FILL option to enhance load performance within ISQL.
COMMIT WORK;
SET LOAD_BUFFER 65536;
SET AUTOSAVE 3000
SET LOAD_ECHO AT_COMMIT;
SET AUTOCOMMIT ON;
SET AUTOLOCK ON;
SET SESSION UNIQUE, REFERENTIAL, CHECK CONSTRAINTS DEFERRED,
DML ATOMICITY AT ROW LEVEL,
FILL;
.
.
.
BEGIN WORK;
LOAD FROM EXTERNAL Price TO PurchDB.SupplyPrice;
LOAD FROM EXTERNAL Parts TO PurchDB.Parts;
.
.
.
COMMIT WORK;
In the above example, a COMMIT WORK is automatically performed when 3000 rows have
been loaded from external files into the database tables. A new transaction is started on
behalf of the user to continue to load remaining rows. Each new transaction uses the
default session isolation level (RR).