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

What’s New in This Manual
HP NonStop SQL/MX Release 3.2 Guide to Stored Procedures in Java—691166-001
viii
Changes to the 540433-001 Manual

Updated the section CALL Statement to Invoke the SPJ on page A-25.
Changes to the H06.16/J06.05 manual:

Supported release statements have been updated to include J-series RVUs.

Updated VALIDATEROUTINE2 internal SPJ details in Effect of Registering an SPJ
on page 1-6.

Updated Table 2-1, Software Products Required for SPJs on page 2-1.

Updated the section Stored Procedure Result Sets on page 3-4.

Updated the section Use of java.sql.Connection Objects on page 3-7.

Added the section Specifying the Maximum Number of Result Sets on page 4-7.

Added the section Using MXCI with SPJ RS on page 5-8.

Added the section Output of the SHOWDDL Command of an SPJ with Result Sets
on page 6-13.

Added the section Using the EXPLAIN function with SPJ RS on page 7-4.

Added a sample ORDERSUMMARY Stored Procedure on page A-23 .
Changes to the 540433-001 Manual
Section New or Changed Information
Section 2, Getting Started
Updated Software Requirements on page 2-1 and
Verifying Software Versions on page 2-2, and added
Configuring the SPJ Environment on Systems Running
H-Series RVUs on page 2-5.
Section 3, Writing SPJ Methods
Explained how to refer to the catalog and schema of
database objects in Referring to Database Objects in an
SPJ Method on page 3-8.
Section 6, Managing SPJs in
NonStop SQL/MX
Removed information about migrating SPJs from
SQL/MX Release 1.8 to SQL/MX Release 2.x because
SQL/MX Release 1.8 is not supported on systems
running H-series RVUs.