OUTER TABLE REFERENCE

Description

The use of OUTER(table-name) or OUTER(view-name) represents a virtual table.

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

OUTER TABLE REFERENCE is not applicable in Snowflake.

Grammar Syntax

Sample Source Patterns

IBM DB2

Code 1

Select * from OUTER(ATable) AS CorrelationName;

Snowflake

Code 1

Select * from
/*** MSC-WARNING - MSCEWI5004 - OUTER TABLE REFERENCE IS NOT APPLICABLE IN SNOWFLAKE. ***/
ATable AS CorrelationName;

Related EWIs

1. MSCEWI5004: OUTER TABLE REFERENCE is not applicable in Snowflake.