15.10 - EXECUTE PROTECTED - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

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;