17.05 - ALTER PROCEDURE Syntax Elements (SQL Form) - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Release Date
January 2021
Content Type
Programming Reference
Publication ID
B035-1144-175K
Language
English (United States)
database_name
The name of a qualifying database containing the SQL procedure to be altered. If database_name is not specified, the default database for the current session is assumed.
user_name
The name of a qualifying database containing the SQL procedure to be altered. If user_name is not specified, the default user for the current session is assumed.
procedure_name
The name of the procedure to be recompiled. 
The SQL procedure you specify must already exist, must have been created with the SPL compile-time option, and cannot be an external procedure. You can recompile only one SQL procedure at a time.

The following optional specifications are stored in the data dictionary with the SQL procedure definition. You can list the options in any order. Each option can be specified at most once.

LANGUAGE SQL
The procedure body is written in the SQL language. This clause is optional.
SQL DCL and DDL statements for administering row-level security are not allowed in a stored procedure.
[ NO ] SPL
The source text of the SQL procedure should [not] be stored in the dictionary.
 You can alter the SPL option for a procedure to NO SPL.
[ NO ] WARNING
Compilation warnings are [not] returned during alteration of the SQL procedure.
You can alter the WARNING option for a procedure to NO WARNING.
AT TIME ZONE
Specifies that the specification that follows sets the time zone for the SQL procedure.
You can only specify AT TIME ZONE if you precede it with either the COMPILE option or the COMPILE ONLY option. You cannot specify AT TIME ZONE by itself or following the EXECUTE PROTECTED or EXECUTE NOT PROTECTED options.
LOCAL
Sets the time zone for the procedure to the system default.


[ sign ] 'quotestring'
Sets the procedure time zone offset to ± quotestring. The default is +.
Vantage implicitly converts the specified expression, as needed and if allowed, to a time zone displacement or time zone string. See Teradata Vantage™ - SQL Data Definition Language Detailed Topics , B035-1184 for a complete list of the implicit data type conversions Vantage performs on ± quotestring data types.