Extended Parallel Server does not support the ALTER PROCEDURE, ALTER ROUTINE, nor ALTER FUNCTION statements. To change the text of an SPL function of Extended Parallel Server, you must first use DROP PROCEDURE to drop it, then make your revisions, and finally use CREATE PROCEDURE to register it again. Make sure to keep a copy of the function text somewhere outside the database, in case you need to re-create a function after it is dropped.
Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]