Previous Topic: Defining a FunctionNext Topic: Writing an External Function in COBOL, PL/I, or Assembler


Invoking a Function

User-defined SQL functions are invoked using the user-defined-function invocation syntax.

Access to user-defined functions is controlled in the same way as for procedures. GRANT and REVOKE statements on a resource type of TABLE are used to give and remove SELECT or DEFINE privileges on a function.

Note: For more information about a user-defined-function, see Expansion of Value-expression and Expansion of User-defined-function.