SQL/MX 3.1 Query Guide (H06.23+, J06.12+)

SQL/MX Operators
HP NonStop SQL/MX Release 3.1 Query Guide—663851-001
7-7
CALL Operator
The following is an example of the CALL operator:
create procedure u300populateA (
in table_name char(20)
)
external name 'TEST300.populateA' language java parameter style
java
external path 'W:/regress/udr' modifies sql data;
prepare TestQuery36 from
call u300populateA('customer');
DESCRIPTION
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
parameter_modes ........ I
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
Token Followed by ... Data Type
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.
TP663851.fm Page 7 Monday, October 17, 2011 11:48 AM