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

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—523725-004
2-29
CALL Statement
CALL Statement
Considerations for CALL
Examples of CALL
The CALL statement invokes a stored procedure in Java (SPJ) in NonStop SQL/MX.
To develop, deploy, and manage SPJs in NonStop SQL/MX, see the SQL/MX Guide to
Stored Procedures in Java.
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 information, see Identifiers on page 6-54.
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-29.
argument-list
accepts arguments for IN, INOUT, or OUT parameters. The arguments consist of
SQL expressions, including host variables or dynamic parameters, separated by
commas:
SQL-expression[{, SQL-expression}...]
Each expression must evaluate to a value of one of these data types:
•
Character value
•
Date-time value
•
Numeric value
Interval value expressions are disallowed in SPJs. For more information, see
Input Parameter Arguments on page 2-30 and Output Parameter Arguments
on page 2-30.
CALL procedure-ref ([argument-list])
procedure-ref is:
[[catalog-name.]schema-name.]procedure-name
argument-list is:
SQL-expression[{, SQL-expression}...]