17.10 - Specifying the C/C++ Function Name - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1147-171K
Language
English (United States)

The CREATE FUNCTION statement provides clauses that identify the C/C++ function name that appears immediately before the left parenthesis in the C/C++ function declaration or the function entry name when the C/C++ object is provided instead of the C/C++ source.

IF CREATE FUNCTION specifies this clause … THEN …
EXTERNAL If the SPECIFIC clause is...
  • specified, then the C/C++ function name must match the name that follows the SPECIFIC clause.
  • not specified, then the C/C++ function name must match the name that follows the CREATE FUNCTION keywords.

If the client is mainframe-attached, then the C/C++ function name must be the DDNAME for the source.

EXTERNAL NAME function_name the C/C++ function name must match function_name.

If the client is mainframe-attached, then function_namemust be the DDNAME for the source.

EXTERNAL NAME 'string 'string' can include the F option to specify the C/C++ function name.

If 'string' does not include the F option, the following rules apply:

If the SPECIFIC clause is...

  • specified, then the C/C++ function name must match the name that follows the SPECIFIC clause.
  • not specified, then the C/C++ function name must match the name that follows the CREATE FUNCTION keywords.