16.20 - EXTERNAL - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-24
dita:mapPath
wkf1512081455740.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

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.
name_on_server ¡include_name
Include.
library_name
Library.
name_on_server ¡object_name
Object.
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.