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

The NSM/web, SQL/MX Database Manager, and Visual Query Planner help systems are accessible
from their respective applications. You can download the Reference, Messages, and Glossary
online help from the HP Software Depot at http://www.software.hp.com. For more information
about downloading the online help, see the SQL/MX Release 3.2 Installation and Upgrade Guide.
These manuals are part of the SQL/MP library of manuals and are essential references for
information about SQL/MP Data Definition Language (DDL) and SQL/MP installation and
management:
Related SQL/MP Manuals
Describes the SQL/MP language elements, expressions,
predicates, functions, and statements.
SQL/MP Reference Manual
Describes how to plan, install, create, and manage an
SQL/MP database. Describes installation and management
commands and SQL/MP catalogs and files.
SQL/MP Installation and Management Guide
This documentation is helpful for understanding the concepts and terminology of this manual:
Other Related Documentation
Describes the HP NonStop Server for Java, a Java
environment that supports programs for the enterprise server.
NonStop Server for Java Programmer's Reference
Describes the JDBC Driver for NonStop SQL/MX
(JDBC/MX), a type 2 driver that enables applications
JDBC Driver for SQL/MX Programmer's Reference
developed for the JDBC application programming interface
(API) to use NonStop SQL/MX.
Describes SQL/JRT (Java Routines and Types), which
extends the ANSI SQL/Foundation standard.
International Standard Database Language SQL—Part 13:
SQL Routines and Types Using the Java™ Programming
Language (SQL/JRT) specification
Describes Java terminology at http://java.sun.com/docs/
glossary.html.
Glossary of Java Technology-Related Terms
New and Changed Information
Changes to the 691166-003 manual:
• Updated the section “SQL/MX UDR Server Process” (page 25).
• Updated the section “Multithreading in an SPJ Environment” (page 27).
• Removed the 'Relink' column from Table 1 (page 32) and the para below the table.
• Updated the reference to the latest manual in “Java Library Path for the JDBC/MX Native
Library” (page 35).
• Reference to connection pooling enabled by default is removed as it is no longer default.
Changes to the 691166-002 manual:
• Updated examples in the following sections:
“How Do I Use SPJs?” (page 18)◦
◦ “JDBC/MX-Based Java Method” (page 54)
◦ “Object Name Qualification Before NonStop SQL/MX Release 2.1.1” (page 55)
◦ “Object Name Qualification in NonStop SQL/MX Release 2.1.1 and Later” (page 55)
◦ “Sales Class” (page 107)
◦ “Payroll Class” (page 109)
New and Changed Information 9