CREATE FUNCTION (External Table)

This CREATE FUNCTION (External Table) statement creates an external table function at the current server. The function returns a result table.

A table function may be used in the FROM clause of a SELECT, and returns a table to the SELECT by returning one row at a time.