Assignment Clause

Description

Introduces the assignment of values to column names.

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

The DELETE statement in Snowflake does not support assigment clause

Grammar Syntax

Sample Source Patterns

IBM DB2

DELETE FROM table1 SET Column1 = NULL"

Snowflake

DELETE FROM
PUBLIC.table1
SET
-- ** MSC-WARNING - MSCEWI1002 - REMOVED NEXT STATEMENT, NOT APPLICABLE IN SNOWFLAKE. UPDATE SET EXPR ELEMENT **
--    Column1 = NULL

Related EWIs

  1. MSCEWI5011: ASSIGNMENT CLAUSE IS NOT SUPPORTED IN SNOWFLAKE

PreviousInclude ColumnsNextWhere Clause

Last updated

Was this helpful?