Modifying routines - ALTER PROCEDURE and ALTER FUNCTION

statement_ALTER_routine ::= ALTER rountine_description;

This statement modifies a routine, whose name is part of the procedure description or function description. This statement assumes that the global routine exists. Routines declared as local inside a block may not be altered.

Alternatively, you can modify a routine from the Control Panel of the 602SQL Client.

The original procedure or function description is replaced with the specified procedure description or function description when modifying a routine. However, description syntax is not checked, therefore you can store a routine which is not finished on the server.

BEWARE: Changes to the routine description are taken into effect after the transaction containing the statement is committed. However, there are some routines that work with the original routine version. These routines are:

statements sent to the server in the same client request as the ALTER routine statement
Already prepared statements that refer to this routine (including statements prepared by other clients)
Already opened cursors (including cursors prepared by other clients)

SQL properties in 602SQL defined by implementation

The ALTER PROCEDURE and ALTER FUNCTION statements cannot be inserted into another procedure, they may only be called separately.

See

Creating Routines - CREATE PROCEDURE and CREATE FUNCTION

Routines Stored on the Server

Deleting a Routine - DROP PROCEDURE and DROP FUNCTION