15.10 - Java External Procedures - 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 external procedures are defined and stored as database objects.

Java external procedure objects contain:

  • Java external procedure name
  • External file reference
  • Data types of the parameters
  • Source file language
  • Data accessing characteristic
  • Parameter passing convention
  • Execution protection mode
  • Character type
  • Platform type
  • Corresponding Tables and Privileges

    Java external procedure information is stored in:

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

  • CREATE OWNER PROCEDURE
  • CREATE EXTERNAL PROCEDURE
  • ALTER PROCEDURE
  • DROP PROCEDURE
  • EXECUTE PROCEDURE
  • Related Topics

    For more information on Java external procedures, see SQL External Routine Programming.