Specifying the CLI Option for the EXTERNAL NAME Package Clause - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Detailed Topics

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
imq1591724555718.ditamap
dita:ditavalPath
imq1591724555718.ditaval
dita:id
B035-1184
lifecycle
previous
Product Category
Teradata Vantage™

If an external procedure supports CLIv2 SQL calls, you must indicate that it does so when you specify the package name for the procedure.

IF the external procedure supports the use of SQL calls using this API … THEN you must specify package_name as …
CLIv2 CLI
The following rules apply to specifying the CLI package option.
  • You can only specify the CLI package name for external procedures.

    You cannot specify this option when you create UDFs or methods.

  • You can specify the CLI package name only once in an EXTERNAL NAME clause.

    You can also specify other user-defined packages, but not another CLI or other Teradata package option.

  • You must specify this option for each external procedure that uses CLIv2 calls to perform SQL.
  • The system links all CLIv2-based external procedures created in 1 database to the same dynamic library in that database, but they are strictly segregated from the standard external procedure and UDF dynamic libraries in the same database.
  • You must run all CLIv2-based external procedures in EXECUTE PROTECTED mode only.

    CLIv2-based external procedures cannot run in EXECUTE NOT PROTECTED mode, and you cannot use the ALTER PROCEDURE (External Form) statement (see ALTER PROCEDURE (External Form)) to change the protection mode of such a procedure to EXECUTE NOT PROTECTED.