Staging Table Definition

Description

A staging table allows incremental maintenance support for deferred materialized query table.

STAGING TABLES are not supported in Snowflake.

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

Grammar Syntax

Sample Source Patterns

IBM DB2

Code 1

create table emp_summary_s for emp_summary propagate immediate;

Snowflake

Code 1

-- ** MSC-ERROR - MSCEWI1021 - STAGING TABLES ARE NOT SUPPORTED **
--create table emp_summary_s for emp_summary propagate immediate

Related EWIs

1. MSCEWI1021: NODE NOT SUPPORTED