Read only Clause

Description

The FOR READ ONLY clause indicates that the result table is read-only and therefore the cursor cannot be referred to in Positioned UPDATE and DELETE statements. FOR FETCH ONLY has the same meaning.

The Read only 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
FOR READ ONLY

Snowflake

 SELECT *
 FROM
   Table1
 -- ** MSC-WARNING - MSCEWI1002 - REMOVED NEXT STATEMENT, NOT APPLICABLE IN SNOWFLAKE.  **
 -- FOR READ ONLY

Known issues

MSCEWI1002: REMOVED STATEMENT, NOT APPLICABLE IN SNOWFLAKE.