EXTERNAL NAME Clause - Analytics Database - Teradata Vantage

SQL Data Definition Language Detailed Topics

Analytics Database
Teradata Vantage
Release Number
June 2022
English (United States)
Last Update
Product Category
Teradata Vantage™

You use the External Name clause to specify the locations of all components needed to create the external routine.

Customers using Vantage delivered as-a-service cannot create their own C++ and Java UDFs, UDMs, UDTs, or External Stored Procedures.

All files included by, or linked to, an external routine must be accessible to the database. These files can reside on a client system or within Analytics Database. Best practice is to keep the source on the client system to ensure that the programmer writing the external routine can control who can access the code. To do this, specify the C option in the external string literal clause to notify the system that the source is stored on the client.

Source code files can be stored on the database server using the S option in the external string literal clause to notify the system that the source is stored on the server. There are specific default server directories for that purpose.

The system automatically copies any client-resident source, header, or object files specified in the External Name clause to the server. Note that the system does not transport external libraries and shared object files, which must be manually installed in Analytics Database.

You can specify the external function name in one of three ways:

  • As an external routine name identifier with optional Parameter Style clause.
  • As an external routine object name.
  • As a coded string that specifies the explicit path to the specified code entity.
    IF the external routine name is ... THEN ...
    an identifier it is the name of the entry point for the external routine object.

    The identifier is case sensitive and must match the C or C++ external routine name.

    a string it is composed of one of the following:
    • a C or C++ external routine entry point name specification
    • an encoded path to the specified code entity

    For a Java external routine, you must specify an external Java reference string.

    The maximum length of the external name string is 1,000 characters.

You can specify more than one encoded string per external routine definition, though some can only be specified once within a list of strings.