Isolation Clause

Description

The optional isolation-clause specifies the isolation level at which the subselect or fullselect is run, and whether a specific type of lock is to be acquired.

The Isolation Clause is not applicable in Snowflake

Click here to navigate to the IBM DB2 docs page for this syntax.

Grammar Syntax

Sample Source Patterns

IBM DB2

SELECT
   *
FROM
   Table1
WITH RR USE AND KEEP EXCLUSIVE LOCKS

Snowflake

 SELECT *
 FROM
   Table1
 -- ** MSC-WARNING - MSCEWI1002 - REMOVED NEXT STATEMENT, NOT APPLICABLE IN SNOWFLAKE.  **
 -- WITH RR USE AND KEEP EXCLUSIVE LOCKS

Known issues

MSCEWI1002: REMOVED STATEMENT, NOT APPLICABLE IN SNOWFLAKE.