Correlation Clause

Description

Can be used within search-condition or assignment-clause to designate a table, view, nickname, or fullselect.

Include-columns:

Specifies a set of columns that are included, along with the columns of table-name or view-name, in the intermediate result table of the DELETE statement when it is nested in the FROM clause of a fullselect.

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

Snowflake does not support the addition of Columns in the correlation clause

Grammar Syntax

Sample Source Patterns

IBM DB2

Single correlation

DELETE FROM table1 As Correlation.Id

Columns correlation

DELETE FROM table1 As table2 (column1, Column2)

Snowflake

Single correlation

DELETE FROM
PUBLIC.table1 As Correlation.Id

Second Tab

DELETE FROM
PUBLIC.table1 AS table2 /*** MSC-ERROR - MSCEWI5006 - INTERMEDIATE RESULT TABLE IS NOT SUPPORTED. ***/

Related EWIs

1. MSCEWI5006: INTERMEDIATE RESULT TABLE IS NOT SUPPORTED.