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.