<img src="02alter65.gif" height="49" width="100"> ALTER PROCEDURE

Informix Guide to SQL: Syntax
SQL Statements

ALTER PROCEDURE

Use the ALTER PROCEDURE statement to change the routine modifiers or pathname of a previously defined external procedure.

Syntax

Element Purpose Restrictions Syntax

parameter_type Data type of the parameter The data type (or list of data types) must be the same types (and specified in the same order) as those specified in the `CREATE PROCEDURE` statement when the procedure was created. Identifier, p. 4-205

procedure Name of the external procedure to modify The procedure must exist (that is, be registered) in the database. If the name does not uniquely identify a procedure, you must enter one or more appropriate values for parameter_type. Database Object Name, p. 4-50

Element	Purpose	Restrictions	Syntax
parameter_type	Data type of the parameter	The data type (or list of data types) must be the same types (and specified in the same order) as those specified in the `CREATE PROCEDURE` statement when the procedure was created.	Identifier, p. 4-205
procedure	Name of the external procedure to modify	The procedure must exist (that is, be registered) in the database. If the name does not uniquely identify a procedure, you must enter one or more appropriate values for parameter_type.	Database Object Name, p. 4-50

Usage

The ALTER PROCEDURE statement allows you to modify an external procedure to tune its performance. With this statement you can modify characteristics that control how the external procedure executes. You can also add or replace related UDRs that provide alternatives for the optimizer, which can improve performance.

All modifications take effect on the next invocation of the procedure.

Privileges

To use the ALTER PROCEDURE statement, you must be the owner of the UDR or have the DBA privilege.

Keywords That Introduce Modifications

Use the following keywords to introduce the items in the external procedure that you want to modify.


Keyword	Purpose
`ADD`	Introduces a routine modifier that you want to add to the external procedure
MODIFY	Introduces a routine modifier for which you want to modify a value
DROP	Introduces a routine modifier that you want to remove from the external procedure
MODIFY EXTERNAL NAME (for external routines only)	Introduces a new location for the executable file
WITH	Introduces all modifications

If the routine modifier is a Boolean value, MODIFY sets the value to be T (that is, it is the equivalent of using the keyword ADD to add the routine modifier). For example, both of the following statements alter the proc1 procedure so that it can be executed in parallel in the context of a parallelizable data query statement.

ALTER PROCEDURE proc1 WITH (MODIFY PARALLELIZABLE) 

ALTER PROCEDURE proc1 WITH (ADD PARALLELIZABLE)

For a related example, see Altering Routine Modifiers Example.

Related Information

Related Statements: ALTER FUNCTION, ALTER ROUTINE, CREATE FUNCTION, CREATE PROCEDURE, DROP FUNCTION, DROP PROCEDURE, and DROP ROUTINE

For a discussion on how to create and use SPL routines, see the Informix Guide to SQL: Tutorial.

For a discussion of how to create and use external routines, see Extending Informix Dynamic Server 2000.