15.10 - UDFs - Teradata Database

Teradata Database Data Dictionary

Product
Teradata Database
Release Number
15.10
Content Type
Administration
User Guide
Publication ID
B035-1092-151K
Language
English (United States)

UDFs are defined and stored as database objects. The UDF source code and object code is stored in the database of the user space.

The UDF objects contain:

  • C source code and object code if its language is not Java
  • Function call name
  • Specific name
  • External name
  • Data types of the parameters
  • Function class
  • Source file language
  • Data accessing characteristic
  • Parameter passing convention
  • Deterministic characteristic
  • Null-call characteristic
  • Execution protection mode
  • Character type
  • Platform type
  • Corresponding Tables and Privileges

    UDF information is stored in:

  • DBC.TVM
  • DBC.UDFInfo (stores attributes)
  • DBC.TVFIelds
  • DBC.AccLogRuleTbl
  • DBC.DBase
  • DBC.AccessRights
  • The privileges relating to UDFs are:

  • ALTER FUNCTION
  • CREATE FUNCTION
  • DROP FUNCTION
  • EXECUTE FUNCTION
  • Related Topics

     

    For more information about ...

    See ...

    tables affected by UDFs

    Chapter 3: “Views Reference.”

    UDFs

    SQL External Routine Programming.