CREATE FUNCTION statements

The OpenText™ Analytics Database provides CREATE statements for each type of user-defined extension.

The OpenText™ Analytics Database provides CREATE statements for each type of user-defined extension. Each CREATE statement adds a user-defined function to the database catalog:

CREATE statement Extension
CREATE FUNCTION (scalar) User-defined scalar functions (UDSFs)
CREATE AGGREGATE FUNCTION User-defined aggregate functions (UDAFs)
CREATE ANALYTIC FUNCTION User-defined analytic functions (UDAnF)
CREATE TRANSFORM FUNCTION User-defined transform functions (UDTFs)
CREATE statements for user-defined load:
CREATE SOURCE Load source functions
CREATE FILTER Load filter functions
CREATE PARSER Load parser functions

The database also provides CREATE FUNCTION (SQL), which stores SQL expressions as functions that you can invoke in a query.