15.10 - EXTERNAL - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

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 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.