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 %ParĂ¢metro

ParĂ¢metro

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