SQL table functions
An SQL table function is a function that is written exclusively in SQL statements and returns a single result table.
An SQL table function can define a parameter as a distinct type, define a parameter for a transition table (for example, the TABLE LIKE ... AS LOCATOR syntax), and include a single SQL PL RETURN statement that returns a result table
The CREATE statement for an SQL table function is an executable statement that can be dynamically prepared only if DYNAMICRULES run behavior is implicitly or explicitly specified.
The ALTER statement for an SQL table function can be embedded in an application program or issued interactively. The ALTER statement is an executable statement that can be dynamically prepared only if DYNAMICRULES run behavior is implicitly or explicitly specified.