SQL/MX 2.x Query Guide (H06.04+, J06.03+)

SQL/MX Operators
HP NonStop SQL/MX Query Guide—540437-005
7-6
CALL Operator
The CALL operator has no child nodes. The description field for this operator contains:
Token Followed by ... Data Type
fragment_id A sequential number assigned to the
fragment. 0 is always the master executor and
1 is reserved for the EXPLAIN plan. Numbers
2 to n will be ESP or DAM fragments.
integer
parent_frag The fragment_id for the parent fragment of the
current fragment. The value is (none) for the
master executor.
integer
fragment_type Master, ESP, or DP2. text
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
language Language of the SPJ method, which is always
Java
text
runtime_options UDR_JAVA_OPTIONS setting under which
the CALL statement was compiled
text
runtime_option_delimiters A single-quoted string representing the option
delimiter character in the
UDR_JAVA_OPTIONS string, which is always
a single space character.
text
max_results_sets The maximum number of result sets the
stored procedure can return.
Integer
The max_results_sets token is supported only on systems running J06.05 and later J-series RVUs and H06.16
and later H-series RVUs.