SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

SQL/MX Statements
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
2-80
CREATE PROCEDURE Statement
CREATE PROCEDURE Statement
Considerations for CREATE PROCEDURE
Examples of CREATE PROCEDURE
The CREATE PROCEDURE statement registers an existing Java method as a stored
procedure in Java (SPJ) within NonStop SQL/MX. To develop, deploy, and manage
SPJs in SQL/MX, see the SQL/MX Guide to Stored Procedures in Java.
CREATE PROCEDURE procedure-ref([sql-parameter-list])
EXTERNAL NAME 'java-method-name [([java-signature])]'
EXTERNAL PATH 'class-or-JAR-file-path'
LANGUAGE JAVA
PARAMETER STYLE JAVA
[LOCATION procedure-label]
[CONTAINS SQL | MODIFIES SQL DATA | READS SQL DATA
| NO SQL]
[DYNAMIC RESULT SETS max-result-sets]
[NOT DETERMINISTIC | DETERMINISTIC]
[ISOLATE | NO ISOLATE]
procedure-ref is:
[[catalog-name.]schema-name.]procedure-name
sql-parameter-list is:
sql-parameter[{, sql-parameter}...]
sql-parameter is:
[parameter-mode] [sql-identifier] sql-datatype
parameter-mode is:
IN
| OUT
| INOUT
java-method-name is:
[package-name.]class-name.method-name
java-signature is:
java-datatype[{, java-datatype}...]
procedure-label is:
[\node.]$volume[.subvolume.filename]
Note. Delimited variables in this syntax diagram are case-sensitive. Case-sensitive variables
include java-method-name, java-signature, class-or-JAR-file-path, and delimited parts of the
procedure-name. The remaining syntax is not case-sensitive.
The
max-result-set can have a value in the range 0–255 from J06.05 and later J-series
RVUs and H06.16 and later H-series RVUs.