Table Function Reference

Description

Table functions return columns of a table, resembling a table created through a simple CREATE TABLE statement. A table function can be used only in the FROM clause of a statement.

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

Table Function Reference is not applicable in Snowflake.

Grammar Syntax

Sample Source Patterns

For the transformation of Table Function Reference, we must comment out the table-UDF-cardinality-clause. This clause is used for performance reasons, and is not relevant in Snowflake.

IBM DB2

Code 1

SELECT * FROM TABLE(TUDF1(3) CARDINALITY 30) AS X;

Snowflake

Code 1

SELECT * FROM TABLE(TUDF1(3)
-- ** MSC-WARNING - MSCEWI1002 - REMOVED NEXT STATEMENT, NOT APPLICABLE IN SNOWFLAKE. CARDINALITY CLAUSE **
--                             CARDINALITY 30
                                           ) AS X;

Note that each function along with the type of it's arguments specified in the table reference must exist, otherwise it will cause errors.

Related EWIs

1. MSCEWI1002: REMOVED, NOT APPLICABLE IN SNOWFLAKE.