Rules for EXECUTE FUNCTION
The following rules apply to EXECUTE FUNCTION.
- The statement does not allow UPDATE, INSERT, MERGE or DELETE functions on an analytic result table (ART).
- You can set the name and column names associated with the result set table, but all other aspects associated with the table are managed by the database software.
- You cannot create an index on the table.
- Column names cannot be renamed when the output is a series or a matrix. For output series and matrixes, the row index is always named ROW_I. For matrixes, the column index is always named COLUMN_I.
- The primary layer of ART can be retrieved using a SELECT statement. Other layers can only be retrieved using the TD_EXTRACT_RESULTS function.
- EXECUTE FUNCTION INTO VOLATILE ART fails if there is a name conflict with an existing table. In that case, you need to drop the existing table or use different name for the volatile ART.
- An EXECUTE FUNCTION statement with no INTO clause returns the rows in the series/matrix ID and row/column axis order.