16.20 - EXECUTE PROTECTED - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-24
dita:mapPath
wkf1512081455740.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

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 the ALTER PROCEDURE (External Form) topic “When to Specify Unprotected Mode” 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 Teradata Database.
For details, see the ALTER PROCEDURE (External Form) topic “When to Specify Unprotected Mode” in Teradata Vantage™ SQL Data Definition Language Detailed Topics , B035-1184 .
You cannot specify this option for Java external procedures.

Example: Altering the Protection Mode of an External Procedure

This example changes the protection mode of the C-language external procedure named my_xsp from protected to not protected.

ALTER PROCEDURE my_xsp LANGUAGE C EXECUTE NOT PROTECTED;