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

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—544517-008
2-62
CREATE PROCEDURE Statement
procedure-ref([sql-parameter[{, sql-parameter}...]])
specifies the name of the SPJ and SQL parameters that correspond to the
signature of the SPJ method.
procedure-ref
specifies an ANSI logical name of the form:
[[catalog-name.]schema-name.]procedure-name
where each part of the name is a valid SQL identifier with a maximum of 128
characters. For more information, see Identifiers on page 6-53.
The procedure-name must be unique among the names of tables, views,
SQL/MP aliases, and procedures within its schema. NonStop SQL/MX does
not support the overloading of procedure names. That is, you cannot register
the same procedure name more than once with different underlying SPJ
methods.
You cannot prefix the procedure name with the name of a user metadata
(UMD) table. For example, you cannot create a procedure named
HISTOGRAMS_MYPROC. These names are reserved for user metadata.
If you do not fully qualify the procedure name, NonStop SQL/MX qualifies it
according to the current settings of CATALOG and SCHEMA. If you set the
NAMETYPE attribute to NSK instead of ANSI and you do not fully qualify the
procedure name, NonStop SQL/MX returns an error. For more information on
the CATALOG, SCHEMA, and NAMETYPE attributes, see the System Defaults
Table on page 10-31.
sql-parameter
specifies an SQL parameter that corresponds to the signature of the SPJ
method:
[parameter-mode] [sql-identifier] sql-datatype
parameter-mode
specifies the mode IN, OUT, or INOUT of a parameter. The default is IN.
IN
specifies a parameter that passes data to an SPJ.
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.