Data Change Table Reference
Description
A data-change-table-reference clause specifies an intermediate result table. This table is based on the rows that are directly changed by the searched UPDATE, searched DELETE, or INSERT statement that is included in the clause.
Click here to navigate to the IBM DB2 docs page for this syntax.
Data Change Table Reference is not supported in Snowflake. The output query can be malformed
Grammar Syntax
Sample Source Patterns
IBM DB2
Snowflake
Related EWIs
MSCEWI5006: INTERMEDIATE RESULT TABLE IS NOT SUPPORTED.
Last updated