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

IBM

SELECT
   *
FROM
   OLD Table(UPDATE T1 SET NAME = 'Tony' where ID = 4)

Snowflake

Snowflake

SELECT
   *
FROM
-- ** MSC-ERROR - MSCEWI5006 - INTERMEDIATE RESULT TABLE IS NOT SUPPORTED. **
--   OLD Table(UPDATE T1 SET NAME = 'Tony' where ID = 4)

Related EWIs

1. MSCEWI5006: INTERMEDIATE RESULT TABLE IS NOT SUPPORTED.