Use the ALTER PROCEDURE statement to change the routine modifiers
or pathname of a previously defined external procedure.
Only Dynamic Server
supports this statement, which is an extension to the ANSI/ISO standard for
SQL.
>>-ALTER-------------------------------------------------------->
.-,------------------.
V |
>--+-PROCEDURE--procedure--(----+----------------+-+--)-+------->
| '-parameter_type-' |
| (1) |
'-SPECIFIC PROCEDURE--| Specific Name |--------------'
.-,------------------------------------------------------------------.
V (2) |
>--WITH(---+-+-ADD----+--| Routine Modifier |-------------------------------+-+-)-><
| +-MODIFY-+ |
| '-DROP---' |
| (3) (4) |
'--------MODIFY EXTERNAL NAME =--| Shared-Object Filename |------'
Notes:
- See Specific Name
- See Routine Modifier
- External routines only
- See Shared-Object Filename
| Element |
Description |
Restrictions |
Syntax |
| procedure |
User-defined procedure to modify |
Must be registered in the database. If the name does not
uniquely identify a function, you must enter one or more appropriate values
for parameter_type. |
Database Object Name |
| parameter_type |
Data type of a parameter |
Must be the same data types (and specified in the same
order) as in the definition of procedure |
Identifier |
The ALTER PROCEDURE
statement enables you to modify an external procedure to tune its performance
by modifying characteristics that control how it 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.
Only the UDR owner or the DBA can use the ALTER PROCEDURE statement.
If the procedure name is not unique among routines registered in the database,
you must enter one or more appropriate values for parameter_type.
The following keywords introduce what you want to modify in procedure.
| Keyword |
Effect |
| ADD |
Add a new routine modifier to the UDR |
| MODIFY |
Change an attribute of a routine modifier |
| DROP |
Delete a routine modifier from the UDR |
MODIFY EXTERNAL NAME
(for external procedures only) |
Replace the file specification of the executable file.
When the IFX_EXTEND_ROLE configuration parameter = ON, this option is valid
only for users to whom the DBSA has granted the EXTEND role. With IFX_EXTEND_ROLE
= OFF (or not set), the UDR owner or the DBA can use this option. |
MODIFY EXTERNAL NAME
(for external procedures only) |
Replace the file specification of the executable file.
(Valid only for users who have the EXTEND role) |
| WITH |
Introduces all modifications |
If the routine modifier is a BOOLEAN value, MODIFY sets the value to be T (equivalent to 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:
ALTER PROCEDURE proc1 WITH (MODIFY PARALLELIZABLE)
ALTER PROCEDURE proc1 WITH (ADD PARALLELIZABLE)
See also Altering Routine Modifiers Example.
Related statements: ALTER ROUTINE, CREATE PROCEDURE, DROP PROCEDURE ,
and DROP ROUTINE .
For a discussion of SPL routines, see the IBM Informix Guide to SQL: Tutorial.
For a discussion of how to create and use external routines, see IBM Informix User-Defined Routines and Data Types Developer's Guide.
For information about how to create C UDRs, see the IBM Informix DataBlade API Programmer's Guide.