ALTER PROCEDURE Examples | Teradata Vantage - ALTER PROCEDURE Examples (External Form) - Teradata Vantage - Analytics Database

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 illustrates the AT TIME ZONE option with a C-language external procedure named spa_tz.

     ALTER PROCEDURE spa_tz
     COMPILE AT TIME ZONE LOCAL;

The AT TIME ZONE option is only valid when you specify it following either the COMPILE option or the COMPILE ONLY option.

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;