Include Columns

Description

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

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

Intermediate result tables are not supported in Snowflake. The output query can be malformed.

Grammar Syntax

Sample Source Patterns

IBM DB2

DELETE FROM table1 
INCLUDE ( 
cDELETE FROM
   table1
INCLUDE ( 
column1 INT,
column2 Varchar(10)
)

Snowflake

DELETE FROM
   PUBLIC.table1
-- ** MSC-ERROR - MSCEWI5006 - INTERMEDIATE RESULT TABLE IS NOT SUPPORTED. **
--INCLUDE (
--column1 INT,
--column2 Varchar(10)
--)

Related EWIs

1. MSCEWI5006: INTERMEDIATE RESULT TABLE IS NOT SUPPORTED.