If an external procedure supports CLIv2 SQL calls, you must indicate by giving package_name the value 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 to change the protection mode of such a procedure to EXECUTE NOT PROTECTED.