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

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—540440-003
2-63
CREATE PROCEDURE Statement
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.
Any Guardian file name you specify must match the designated schema
subvolume name for the schema in which the SPJ is being created. Otherwise,
NonStop SQL/MX returns an error.
filename
is an optional Guardian file name. The name must be eight characters long in
length and must end with the digits “00” (zero zero).
NO SQL
specifies that the SPJ cannot perform SQL operations.