1 CREATE
2 %RoutineType
3 RoutineName (
4 %ParameterList
5 )
4? %ReturnType
5? %Language
6? %ResultSet
7 %RoutineBody

RoutineType

1 PROCEDURE
1 FUNCTION

ParameterList

1+ ,
1 %Parameter

Parameter

1 IN
1 OUT
1 INOUT (1) 
2 ParameterName
3? CONSTANT
3.1 DataType
3 NAMESPACE (2) 
3 NAME

ReturnType

1 RETURNS DataType

Language

1 LANGUAGE
2 ESQL
2 DATABASE
2 JAVA

ResultSet

1 DYNAMIC RESULT SETS integer

RoutineBody

1 Statement
1 EXTERNAL NAME ExternalRoutineName