Update Clause

Description

The FOR UPDATE clause identifies the columns that can be targets in an assignment clause in a subsequent positioned UPDATE statement. Each column-name must be unqualified and must identify a column of the table or view identified in the first FROM clause of the fullselect.

The Update 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 UPDATE OF
   COL1,
   COL2

Snowflake

 SELECT *
 FROM
   Table1
 -- ** MSC-WARNING - MSCEWI1002 - REMOVED NEXT STATEMENT, NOT APPLICABLE IN SNOWFLAKE.  **
--FOR UPDATE OF
--   COL1,
--   COL2

Known issues

MSCEWI1002: REMOVED STATEMENT, NOT APPLICABLE IN SNOWFLAKE.