15.00 - Function of ALTER PROCEDURE (External Form) Requests - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1184-015K

Function of ALTER PROCEDURE (External Form) Requests

ALTER PROCEDURE (External Form) enables you to control whether an existing external procedure can be executed directly or indirectly as a separate process by Teradata Database. As a general rule, you should only permit a function to run in direct execution mode after is has been thoroughly debugged. When you create a new external procedure, it executes indirectly in protected execution mode by default (see “CREATE PROCEDURE (External Form)/ REPLACE PROCEDURE (External Form)” on page 422 for details).

ALTER PROCEDURE (External Form) also allows you to recompile or relink an external procedure and redistribute it (and its associated JAR file if the external routine is written in Java) using the COMPILE option. This option is primarily intended for use by DBAs to recompile existing procedures that have been moved to another platform, system, or restored database.