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

External procedures are defined and stored as database objects. The source code and the object code are stored in the database of the user space.

External procedure objects contain:

  • C/C++ source and object code for the external procedure if its language is not Java.
  • External procedure name
  • External name
  • 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

    External procedures information is stored in:

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

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

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