EXECUTE PROTECTED - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
ncd1596241368722.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
dita:id
B035-1144
lifecycle
previous
Product Category
Teradata Vantage™

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.