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:

1 data-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?
10 COMMIT ON RETURN YES