SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—540440-003
2-59
CREATE PROCEDURE Statement
ADD FIRST KEY 'O' LOCATION $data2,
ADD FIRST KEY 'T' LOCATION $data3);
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 integer]
[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.