SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—523725-004
2-65
CREATE PROCEDURE Statement
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 system 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.
CONTAINS SQL | MODIFIES SQL DATA | READS SQL DATA
specifies that the SPJ can perform SQL operations. Currently, all the options allow
an SPJ to read and modify SQL data. If you do not specify an SQL access mode,
the default is CONTAINS SQL.