15.10 - Java 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)

Java user-defined functions (UDFs) are defined and stored as database objects.

Java UDF objects contain:

  • 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

    Java UDF information is stored in:

  • DBC.TVM (stores attributes)
  • DBC.TVFields
  • DBC.AccLogRuleTbl
  • DBC.DBase
  • DBC.AccessRights
  • DBC.Routine_Jar_Usage (stores attributes)
  • DBC.UDFInfo (stores attributes)
  • The privileges relating to Java UDFs are the following:

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

     

    For more information about ...

    See ...

    Java UDFs

    SQL External Routine Programming.

    tables affected by UDFs

    Chapter 3: “Views Reference.”