ALTER PROCEDURE Examples | VantageCloud Lake - ALTER PROCEDURE Examples (External Form) - Teradata Vantage

Example: Recompiling an External Procedure

This example recompiles the C-language external procedure named my_xsp.

ALTER PROCEDURE my_xsp LANGUAGE C COMPILE;

Example: Using the AT TIME ZONE Option with an External Procedure

This example shows the AT TIME ZONE option with a C-language external procedure named spa_tz.

ALTER PROCEDURE spa_tz
COMPILE AT TIME ZONE LOCAL;

Specify AT TIME ZONE only after COMPILE or COMPILE ONLY.

For example, the following request is not valid because the AT TIME ZONE specification precedes the COMPILE specification in the request.

ALTER PROCEDURE spa_tz
LANGUAGE C
AT TIME ZONE COMPILE 'gmt';

The same request, when the options are specified in the correct sequence, is valid and alters the procedure as requested.

ALTER PROCEDURE spa_tz
LANGUAGE C
COMPILE AT TIME ZONE 'gmt';

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;