Table UDFs and TPFs have some restrictions.
The TEMPORARY PROCEDURE clause is not allowed for any external procedures. Attempting to create a temporary external procedure results in an error at creation time.
The NO RESULT SET clause is not allowed. Table UDFs and TPFs must explicitly declare the contents of their results.
If the optional DYNAMIC RESULT SETS integer-expression clause is specified, the value must be set to 1. Table UDFs and TPFs do not return multiple result sets.
A table UDF or TPF cannot be referenced in a CALL SQL statement or EXEC embedded SQL statement. A table UDF or TPF can be referenced only in a FROM clause of a SQL statement.
The LANGUAGE clause cannot be used for table UDFs or TPFs. If the LANGUAGE clause is present, syntax errors are reported at execution time.
The parameter clause is limited to keyword IN; INOUT and OUT keywords are not supported for table UDFs or TPFs.
The EXTERNAL NAME clause has the same syntax as scalar and aggregate UDFs.