1 CREATE PROCEDURE ProcedureName ( %ParameterList )
2? %ReturnType
3? %Language
4 %RoutineBody

ParameterList

1+ ,
1 %Parameter

Parameter

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

ReturnType

1 RETURNS DataType

Language

1 LANGUAGE
2 ESQL
2 DATABASE
2 JAVA

RoutineBody

1 Statement
1 EXTERNAL NAME ExternalRoutineName