17.10 - EXECUTE PROTECTED - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

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

Change the execution mode for the specified external procedure from unprotected mode to protected mode.


The EXECUTE PROTECTED option causes the external procedure to execute as a separate process. For details, see ALTER PROCEDURE (External Form) in Teradata Vantage™ - SQL Data Definition Language Detailed Topics, B035-1184.


An external SQL procedure linked with CLIv2 can only execute in protected mode.

A Java external SQL procedure can only execute in protected mode.

NOT
Change the execution mode for the specified external procedure from protected mode to unprotected mode. The EXECUTE NOT PROTECTED option causes the external procedure to execute directly on the Vantage.
For details, see ALTER PROCEDURE (External Form) in Teradata Vantage™ - SQL Data Definition Language Detailed Topics, B035-1184.
You cannot specify this option for Java external procedures.