SQL/MX 3.2.1 Guide to Stored Procedures in Java (H06.26+, J06.15+)

• Added the section Using the EXPLAIN function with SPJ RS (page 103).
• Added a sample ORDERSUMMARY Stored Procedure (page 121).
Changes to the 540433-001 Manual
New or Changed InformationSection
Updated Software Requirements (page 32) and Verifying
Software Versions (page 33) and added Configuring the
Chapter 2: Getting Started
SPJ Environment on Systems Running H-Series RVUs
(page 35)
Explained how to refer to the catalog and schema of
database objects in Referring to Database Objects in an
SPJ Method (page 55)
Chapter 3: Writing SPJ Methods
Removed information about migrating SPJs from SQL/MX
Release 1.8 to SQL/MX Release 2.x because SQL/MX
Chapter 6: Managing SPJs in NonStop SQL/MX
Release 1.8 is not supported on systems running H-series
RVUs.
Document Organization
Introduces SPJs in NonStop SQL/MX, describes steps for
using SPJs, describes the benefits of using SPJs, describes
Chapter 1: Introduction
the process of registering and invoking SPJs in NonStop
SQL/MX, and describes the SPJ environment.
Describes the software requirements and system
configuration for registering and invoking SPJs in NonStop
SQL/MX.
Chapter 2: Getting Started
Provides guidelines for writing and compiling a Java method
to be used as the body of an SPJ.
Chapter 3: Writing SPJ Methods
Explains how to create an SPJ, drop an SPJ, and alter an
SPJ in NonStop SQL/MX.
Chapter 4: Registering SPJs in NonStop SQL/MX
Explains how to execute an SPJ by using the CALL statement
in NonStop SQL/MX.
Chapter 5: Invoking SPJs in NonStop SQL/MX
Describes management tasks related to SPJs, such as
granting privileges for invoking SPJs, showing the SPJs that
Chapter 6: Managing SPJs in NonStop SQL/MX
exist in a database, and using SPJs in a distributed
database environment.
Describes how to improve and monitor the performance of
SPJs and provides guidelines for troubleshooting common
problems.
Chapter 7: Performance and Troubleshooting
Provides SPJ methods that demonstrate business logic in an
SQL/MX database.
Appendix A: Sample SPJs
Examples in This Manual
The examples and sample SPJs in this manual refer to the SQL/MX sample database. To install
the sample database, see the SQL/MX Quick Start. For information about the schema and tables
of the sample database, see the SQL/MX Reference Manual.
Most of the examples and sample SPJs can query both SQL/MP and SQL/MX tables of the SQL/MX
sample database. To query SQL/MP tables, use the NonStop SQL/MX Release 1.8 sample
database. To query SQL/MX tables, use the NonStop SQL/MX Release 2.x sample database.
NOTE: The SQL/MX Release 2.x sample database uses SQL/MX format tables. To install the
sample database, you must have a license to use SQL/MX DDL statements. To acquire this license,
purchase product T0394. Without this product, you cannot install the sample database. An error
message informs you that the system is not licensed.
Document Organization 11