SQL/MX 3.2 Guide to Stored Procedures in Java (H06.25+, J06.14+)

Invoking SPJs in NonStop SQL/MX

HP NonStop SQL/MX Release 3.2 Guide to Stored Procedures in Java—691166-001

5-4

Specifying the Name of the SPJ

In the CALL statement, specify the name of an SPJ that you have already registered in

NonStop SQL/MX. Qualify the procedure name with the same catalog and schema that

you specified in the CREATE PROCEDURE statement. For example:

SET SCHEMA samdbcat.persnl;

CALL adjustsalary(202, 5.5, ?);

If you do not fully qualify the procedure name, NonStop SQL/MX qualifies it according

to the current settings of CATALOG and SCHEMA in the SYSTEM_DEFAULTS table.

For more information, see the SQL/MX Reference Manual.