Example 1: The following SET TRANSACTION statement sets the isolation level to NONE (equivalent to specifying *NONE on the SQL precompiler command).
EXEC SQL SET TRANSACTION ISOLATION LEVEL NO COMMIT;
Example 2: The following SET TRANSACTION statement sets the isolation level to SERIALIZABLE.
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.