Update Target
Description
Identifies the object of the update operation.
Click here to navigate to the IBM DB2 docs page for this syntax.
Snowflake only allows tables as the object of the update operation. The output query can be malformed.
Grammar Syntax

Sample Source Patterns
IBM DB2
UPDATE TABLE1
SET Column1 = 1;
Snowflake
UPDATE TABLE1
SET Column1 = 1;
Related EWIs
MSCEWI5004: ONLY OUTER TABLE REFERENCE IS NOT APPLICABLE IN SNOWFLAKE.
MSCEWI5006: INTERMEDIATE RESULT TABLE IS NOT SUPPORTED.
Last updated
Was this helpful?