15.00 - Attributes Changed by ALTER PROCEDURE (SQL Form) - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

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

Attributes Changed by ALTER PROCEDURE (SQL Form)

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” on page 941.

  • 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.