- 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 must [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 SET TIME ZONE Usage Notes for more information.