1  –  ADD routine-clause

    Allows new functions and procedures to be added to the module.
    Refer to the CREATE MODULE for details on the routine-clause. The
    END MODULE clause must be used to end the ALTER MODULE clause to
    provide an unambiguous statement termination.

2  –  COMMENT_IS

    Adds a comment about the module. Enclose the comment within
    single quotation marks (')  and separate multiple lines in a
    comment with a slash mark (/).  This clause is equivalent to the
    COMMENT ON MODULE statement.

3  –  COMPILE

    Recompiles stored routines in the module. Any that were
    marked invalid will have this flag cleared if the compile was
    successful.

4  –  drop-routine-clause

    The DROP FUNCTION and DROP PROCEDURE clauses will drop the named
    routines from this module. All DROP clauses are executed prior to
    the COMPILE and ADD clauses in this ALTER statement.

5  –  END_MODULE

    This terminating clause is required when using ADD FUNCTION or
    ADD PROCEDURE since there is no way to distinguish between the
    end of a compound statement and the end of the ALTER MODULE
    statement.

6  –  RENAME_TO

    Changes the name of the module being altered. See the RENAME for
    further discussion. If the new name is the name of a synonym then
    an error will be raised.

    The RENAME TO clause requires synonyms be enabled for this
    database. Refer to the ALTER DATABASE SYNONYMS ARE ENABLED
    clause. Note that these synonyms may be deleted if they are no
    longer used by database definitions or applications.

    The old name will be used to create a synonym for the new name of
    this module. This synonym can be dropped if the name is no longer
    used by applications.