16.20 - EXTERNAL - Teradata Database - Teradata Vantage NewSQL Engine

Introduction to the mandatory external method body reference clause.

This clause can specify either:

• The keyword EXTERNAL only.
• The keywords EXTERNAL NAME plus an external method name, with optional Parameter Style specification

NAME external_method_name

Entry point for the method object. This name must be unique within the SYSUDTLIB database.

For information about naming database objects, see Teradata Vantage™ SQL Fundamentals, B035-1141.

Case is significant and must match the C or C++ method name.

NAME external_string_literal

A string that specifies the source and object components needed to build the method.

Depending on the initial code in the sequence, the string specifies either the C/C++ object name for the method or an encoded name or path for the components needed to create the method.

The following list briefly documents the path specifications for the external method. The character ¡ represents an arbitrary user-defined delimiter.

You must use the same delimiter throughout the string specification. The first entry listed is the file type and the second entry is the syntax you must use to specify that file type.

I¡name_on_server ¡include_name

Include.

L¡library_name

Library.

O¡name_on_server ¡object_name

Object.

S¡name_on_server ¡source_name

Source.

C

The source or object code for the method is stored on the client and the string that follows is the path to its location.

S

The source or object code for the method is stored on the server and the string that follows is the path to its location.