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

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—540440-003
2-27
CALL Statement
EXEC SQL COMMIT WORK END-EXEC.
ELSE
EXEC SQL ROLLBACK WORK END-EXEC.
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 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 more information, see Identifiers on page 6-52.
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-30.
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
CALL procedure-ref ([argument-list])
procedure-ref is:
[[catalog-name.]schema-name.]procedure-name
argument-list is:
SQL-expression[{, SQL-expression}...]