ONLY TABLE REFERENCE

Description

The use of ONLY(table-name) or ONLY(view-name) means that the rows of the applicable subtables or subviews are not included in the intermediate result table.

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

ONLY TABLE REFERENCE is not applicable in Snowflake.

Grammar Syntax

Sample Source Patterns

IBM DB2

Code 1

Select * from ONLY(ATable) AS CorrelationName;

Snowflake

Code 1

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

Related EWIs

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