SQL Reference for Table UDF and TPF Queries

SQL statement reference for queries referencing table UDFs and TPFs.

• ALTER PROCEDURE Statement
  Replaces an existing procedure with a modified version. Include the entire modified procedure in the ALTER PROCEDURE statement, and reassign user permissions on the procedure.
• CREATE PROCEDURE Statement (Table UDF)
  Creates an interface to an external table user-defined function (table UDF). Users must be specifically licensed to use table UDFs.
• CREATE FUNCTION Statement
  Creates a new function in the database.
• DEFAULT_TABLE_UDF_ROW_COUNT Option
  Enables you to override the default estimate of the number of rows to return from a table UDF (either a C, C++, or Java table UDF).
• TABLE_UDF_ROW_BLOCK_CHUNK_SIZE_KB Option
  Controls the size, in kilobytes, for server-allocated row blocks. Row blocks are used by Table UDFs and TPFs.
• FROM Clause
  Specifies the database tables or views involved in a SELECT statement.
• SELECT Statement
  Retrieves information from the database.