16.20 - Attributes Changed by ALTER PROCEDURE (SQL Form) - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Detailed Topics

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1184-162K
Language
English (United States)
ALTER PROCEDURE can alter the following attributes of the recompiled SQL procedure.
  • Platform.

    This is an implicit change and cannot be specified by an ALTER PROCEDURE request.

  • TDSP version number.

    This is an implicit change and cannot be specified by an ALTER PROCEDURE request.

    For information about procedure version numbers, see HELP PROCEDURE.

  • Creation time zone.

    This is an explicit change that you specify using the AT TIME ZONE option.

You can also change one or all of the following attributes:
  • SPL to NO SPL.

    You cannot change NO SPL back to SPL.

  • WARNING to NO WARNING and vice versa.