Micro Focus Studio Enterprise Edition Test Server > Programming > Mainframe Programming > SQL Option for DB2 > Reference > SQL Reference > SQL Statements > CREATE FUNCTION

CREATE FUNCTION

External Scalar

CREATE FUNCTION (external scalar)

The function is written in a programming language and returns a scalar value. The external executable is registered with an application server along with various attributes of the function.

External Table

CREATE FUNCTION (external table)

The function is written in a programming language and returns a complete table. The external executable is registered with an application server along with various attributes of the function.

Sourced

CREATE FUNCTION (sourced)

The function is implemented by invoking another function (either built-in, external, or sourced) that is already registered with an application server.