SQL/MX 2.x Query Guide (G06.24+, H06.03+)

Operators and Operator Groups
HP NonStop SQL/MX Query Guide—523728-003
7-4
CALL Operator
CALL Operator
User-Defined Routine (UDR)
The CALL operator indicates that a UDR was used.
The CALL operator has no child nodes. The description field for this operator contains:
Sort SORT Operator
Stored Function EXPLAIN Operator
Tuple EXPR Operator
TUPLELIST Operator
VALUES Operator
Token Followed by ... Data Type
input_values Input values to the CALL statement.
One SQL/MX expression is returned
for each IN or INOUT parameter.
Nothing is returned for OUT
parameters.
expr(text)
parameter_modes A sequence of characters that
specifies SQL parameter modes for
the procedure. I is used for an IN
parameter, O for an OUT parameter,
and N for an INOUT parameter.
Characters are separated by a single
space. The value none is returned if
the procedure has no SQL
parameters.
text
routine_name ANSI name of the procedure. text
routine_label Guardian name of the stored
procedure label.
text
sql_access_mode SQL access mode of the procedure. text
external_name Java method name. text
external_path OSS directory or JAR file path that
contains the Java class file.
text
external_file Java class name, possibly prefixed
by a package name, that contains
the SPJ method.
text
signature Java signature of the SPJ method in
internal Java Virtual Machine (JVM)
format.
text
Group Operator