Attributes Changed by ALTER PROCEDURE (SQL Form) | Teradata Vantage - 17.10 - Attributes Changed by ALTER PROCEDURE (SQL Form) - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Detailed Topics

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1184-171K
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.