Examples

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