15.10 - EXECUTE PROTECTED - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Release Number
15.10
Published
December 2015
Content Type
Programming Reference
Publication ID
B035-1144-151K
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 the ALTER PROCEDURE (External Form) topic “When to Specify Unprotected Mode” in SQL Data Definition Language Detailed Topics.


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 SQL Data Definition Language Detailed Topics.
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;