SQL/MX Guide to Stored Procedures in Java (G06.24+, H06.03+)

Introduction
HP NonStop SQL/MX Guide to Stored Procedures in Java—523727-004
1-4
Benefits of SPJs
7. Maintain privileges and manage the metadata of SPJs in the database
environment. See Section 6, Managing SPJs in NonStop SQL/MX.
8. Monitor the performance of SPJs and resolve common problems with SPJs in
NonStop SQL/MX. See Section 7, Performance and Troubleshooting.
Benefits of SPJs
SPJs provide an efficient and secure way to implement business logic in an SQL/MX
database. SPJs offer the advantages discussed next.
Java Methods Callable From NonStop SQL/MX
With support for SPJs, Java methods are callable from any SQL/MX application on a
NonStop system. For example, you can invoke the same SPJ method from embedded
SQL programs in C, C++, or COBOL and from HP NonStop ODBC/MX clients. By
using NonStop SQL/MX to invoke Java methods, you can extend the functionality of an
SQL/MX database and share business logic among different applications.
For more information, see Section 5, Invoking SPJs in NonStop SQL/MX.
Figure 1-1. Different Applications Calling the Same SPJ
VST027.vsd
NonStop SQL/MX
Stored Procedure
samdbcat.sales.lowerprice()
SPJ Method
Sales.lowerPrice
SQL/MP or SQL/MX
Database Table
Embedded SQL Program in C++
CALL lowerprice()
ODBC/MX Client Application
CALL lowerprice();
JDBC/MX Application
CALL lowerprice();