Specifying the C/C++ Function Name - Analytics Database - Teradata Vantage

SQL External Routine Programming

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-07-11
dita:mapPath
iiv1628111441820.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
B035-1147
lifecycle
latest
Product Category
Teradata Vantage™

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.