Include Columns

Description

Specifies a list of columns to be included in the intermediate result table of the UPDATE statement.

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

Intermediate result tables are not supported in Snowflake, the output code can be malformed

Grammar Syntax

Sample Source Patterns

IBM DB2

UPDATE EMP INCLUDE(old_comm DECIMAL (7,2))
UPDATE TABLE5
INCLUDE (col1 INT, col2 Varchar(10))
SET Column1 = 1;

Snowflake

UPDATE PUBLIC.TABLE5
-- ** MSC-ERROR - MSCEWI5006 - INTERMEDIATE RESULT TABLE IS NOT SUPPORTED. **
--INCLUDE (col1 INT, col2 Varchar(10))
SET Column1 = 1;

Related EWIs

1. MSCEWI5006: INTERMEDIATE RESULT TABLE IS NOT SUPPORTED.