MSCEWI5004

ONLY/OUTER TABLE REFERENCE NOT APPLICABLE IN SNOWFLAKE

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

Severity

Low

Description

This message is shown when an OUTER or ONLY table reference is found in a FROM clause inside of a SELECT statement. These clauses are used to include or exclude data values from subtables in the intermediate result table of the SELECT statement. Subtables are related to typed tables in the DB2 database, that are created with the OF clause of the CREATE TABLE statement, which is also not supported in Snowflake. Since these clauses provoke an error in Snowflake, they are removed and a Warning is added.

Code example

Input code:

Select * from OUTER(ATable);
Select * from ONLY(ATable);

Output code:

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

Recommendations

• If you need more support, you can email us at [email protected]