1 ALTER 2 PROCEDURE procedure-name 2.1? ( 2.1.1+ , 2.1.1?parameter-type 2.1.2 ) 2 SPECIFIC PROCEDURE specific-name 3! ALTER 3.1 option-list 3 REPLACE routine-specification routine-specification: 1? 1 ( 1.1? 1.1+ , 1.1 parameter-declaration 1.2 ) 2? 2 option-list 3? SET OPTION-statement 4 SQL-routine-body parameter-declaration: 1! IN 1? 1 OUT 1 INOUT 2 parameter-name data-type parameter-type: 1data-type data-type: 1 built-in-type 1 distinct-type-name option-list: 1! NOT DETERMINISTIC 1? 1 DETERMINISTIC 2 (1) 3! MODIFIES SQL DATA 3? 3 READS SQL DATA 3 CONTAINS SQL 4! CALLED ON NULL INPUT 5!INHERIT SPECIAL REGISTERS 6! DYNAMIC RESULT SETS 0 6? 6 DYNAMIC RESULT SETS integer 7? 7 ALLOW DEBUG MODE 7 DISABLE DEBUG MODE 7 DISALLOW DEBUG MODE 8! FENCED 8? 8 NOT FENCED 9! OLD SAVEPOINT LEVEL 9? 9 NEW SAVEPOINT LEVEL 10!COMMIT ON RETURN NO 10? 10COMMIT ON RETURN YES
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.