1 CREATE 2 %RoutineType 3 RoutineName ( 4 %ParameterList 5 ) 6? %ReturnType 7? %Language 8? %ResultSet 9 %RoutineBody RoutineType 1 FUNCTION 1 PROCEDURE ParameterList 1+ , 1 %Parameter Parameter 1 IN 1 OUT (1) 1 INOUT 2 ParameterName 3.0? CONSTANT 3.1 DataType 3 NAMESPACE (2) 3 NAME ReturnType 1 RETURNS DataType Language 1 LANGUAGE 2 ESQL 2 DATABASE (3) 2 JAVA ResultSet 1 DYNAMIC RESULT SETS integer RoutineBody 1 Statement 1 EXTERNAL NAME ExternalRoutineName