SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—544517-008
2-65
CREATE PROCEDURE Statement
Java method definition within the class file. Each Java data type that
corresponds to an OUT or INOUT parameter must be followed by empty
square brackets ([ ]), such as java.lang.Integer[].
java-datatype
specifies a mappable Java data type. For the mapping of the Java data
types to SQL/MX data types, see sql-datatype on page 2-63.
EXTERNAL PATH 'class-file-path'
specifies a case-sensitive string identifying the OSS directory or the JAR file path
where the Java class file that contains the SPJ method resides.
Specify package names in the EXTERNAL NAME clause, not the EXTERNAL
PATH clause.
LANGUAGE JAVA
specifies that the external user-defined routine is written in the Java language.
PARAMETER STYLE JAVA
specifies that the run-time conventions for arguments passed to the external
user-defined routine are those of the Java language.
LOCATION procedure-label
specifies a Guardian physical name and location for the stored procedure label.
For more information on the procedure label, see the SQL/MX Guide to Stored
Procedures in Java.
[\node.]$volume[.subvolume.filename]
node
is the name of a node on the Expand network. The node can be any node
where the catalog of the SPJ is visible.
volume
is the name of an audited, non-SMF DAM volume on the specified node (or the
Guardian volume named in the =_DEFAULTS define if none is specified).
subvolume
is the designated schema subvolume for the schema in which the SPJ is being
created. Follow these guidelines when using SQL/MX subvolume names:
•
The name must begin with the letters ZSD, followed by a letter, not a digit.
•
The name must be exactly eight characters long.