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;

UPDATE (SELECT EMPNO, SALARY, COMM,
     AVG(SALARY) OVER (PARTITION BY WORKDEPT),
     AVG(COMM) OVER (PARTITION BY WORKDEPT)
     FROM EMPLOYEE E) AS E(EMPNO, SALARY, COMM, AVGSAL, AVGCOMM)
   SET (SALARY, COMM) = (AVGSAL, AVGCOMM)
   WHERE EMPNO = '000120';

Snowflake

UPDATE TABLE1
	SET Column1 = 1;

UPDATE
-- ** MSC-ERROR - MSCEWI5006 - INTERMEDIATE RESULT TABLE IS NOT SUPPORTED. **
--       (SELECT EMPNO, SALARY, COMM,
--     AVG(SALARY) OVER (PARTITION BY WORKDEPT),
--     AVG(COMM) OVER (PARTITION BY WORKDEPT)
--     FROM EMPLOYEE E)
                      AS E
-- ** MSC-ERROR - MSCEWI5006 - INTERMEDIATE RESULT TABLE IS NOT SUPPORTED. **
--                          (EMPNO, SALARY, COMM, AVGSAL, AVGCOMM)
     SET
     SALARY = AVGSAL,
     COMM = AVGCOMM
   WHERE EMPNO = '000120';

MSCEWI5004: ONLY OUTER TABLE REFERENCE IS NOT APPLICABLE IN SNOWFLAKE.
MSCEWI5006: INTERMEDIATE RESULT TABLE IS NOT SUPPORTED.

PreviousUPDATE STATEMENT NextPeriod Clause

Last updated 3 years ago

Was this helpful?

Description

Grammar Syntax

Sample Source Patterns

IBM DB2

Snowflake

Related EWIs