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

Contents
HP NonStop SQL/MX Guide to Stored Procedures in Java—540433-003
iii
3. Writing SPJ Methods (continued)
3. Writing SPJ Methods (continued)
Use of java.sql.Connection Objects 3-7
JDBC/MX-Based Java Method
3-8
Referring to Database Objects in an SPJ Method
3-8
Exception Handling
3-11
Handling Java Exceptions
3-11
User-Defined Exceptions
3-11
Writing Data to a File or Terminal
3-13
Compiling Java Classes
3-14
4. Registering SPJs in NonStop SQL/MX
Creating an SPJ 4-1
Required Privileges for Creating an SPJ
4-1
Effect of Creating an SPJ
4-1
Using the CREATE PROCEDURE Statement 4-2
Naming the Stored Procedure 4-3
Specifying SQL Parameters
4-4
Specifying the Maximum Number of Result Sets 4-7
Specifying the SPJ Method
4-8
Specifying the External Path
4-10
Naming the Procedure Label 4-11
Specifying an SQL Access Mode 4-12
Dropping an SPJ
4-13
Required Privileges for Dropping an SPJ 4-13
Effect of Dropping an SPJ 4-13
Using the DROP PROCEDURE Statement
4-13
Altering an SPJ and Its Java Class 4-14
Changes to the External Path 4-15
Changes to the External Name 4-16
Changes to the Java Signature 4-17
5. Invoking SPJs in NonStop SQL/MX
Calling an SPJ 5-1
Required Privileges for Calling an SPJ 5-1
Effect of Calling an SPJ 5-2
Transaction Behavior 5-2
Using the CALL Statement 5-3
Specifying the Name of the SPJ 5-3
Listing the Arguments of the SPJ
5-4