Modifying Schema, View, Table, and Routine Definitions › Maintaining Routines and Their Keys › Modifying a Routine

Modifying a Routine

Types of Changes You Can Make

The following attributes of a routine can be changed:

• External name of the routine
• Estimated rows and I/O counts
• Work area usage, size and attributes
• Mode in which the routine executes
• Definition timestamp
• Default database in effect when the routine is invoked
• Whether the routine should share the encompassing SQL session's transaction
• Programming language that the routine is written in

Additionally, you can also add or remove a key from a procedure or table procedure. Keys are used to assist CA IDMS/DB in calculating the amount of resources that will be consumed by a given routine invocation.

Statements That Modify Routines

To modify a routine's attributes, use one of the following statements:

• ALTER PROCEDURE to alter an SQL procedure
• ALTER TABLE PROCEDURE to alter a table procedure
• ALTER FUNCTION to alter an SQL scalar function defined by a CREATE FUNCTION statement

To associate a new key with a procedure or table procedure, use the CREATE KEY statement. To drop a key, use a DROP KEY statement.

Examples

In the following example, function CORP_DATE is altered to change the external name of the function.

alter function corp_date external name corpdate: