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

HP NonStop SQL/MX Guide to Stored Procedures in Java—523727-004
ix
About This Manual
This manual describes how to develop, deploy, and manage stored procedures in Java
(SPJs) in NonStop SQL/MX. NonStop SQL/MX is a relational database management
system based on the ANSI/ISO/IEC 9075:1999 SQL standard, commonly referred to
as SQL:1999, for the HP NonStop server.
Throughout this manual, references to NonStop SQL/MX Release 2.x indicate SQL/MX
Release 2.0, 2.1, and subsequent releases until otherwise indicated in a replacement
publication.
Audience
This manual is intended for application programmers and database administrators who
plan to implement SPJs within an SQL/MX database. The reader should know:
•
The Java programming language
•
JDBC and the HP NonStop JDBC Driver for SQL/MX (JDBC/MX)
•
Structured query language (SQL) and SQL/MX terms and concepts
Although not required, it helps to be familiar with the part of the ANSI SQL/Foundation
standard called SQL/JRT (Java Routines and Types).
Organization
Section 1, Introduction Introduces SPJs in NonStop SQL/MX, describing
steps for using SPJs, the benefits of using SPJs,
the process of registering and invoking SPJs in
NonStop SQL/MX, and the SPJ environment.
Section 2, Getting Started
Describes the software requirements and system
configuration for registering and invoking SPJs in
NonStop SQL/MX.
Section 3, Writing SPJ Methods
Provides guidelines for writing and compiling a
Java method to be used as the body of an SPJ.
Section 4, Registering SPJs in NonStop
SQL/MX
Explains how to create an SPJ, drop an SPJ, and
alter an SPJ in NonStop SQL/MX.
Section 5, Invoking SPJs in NonStop
SQL/MX
Explains how to execute an SPJ by using the
CALL statement in NonStop SQL/MX.