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
iv
5. Invoking SPJs in NonStop SQL/MX (continued)
5. Invoking SPJs in NonStop SQL/MX (continued)
Invoking SPJs in MXCI 5-6
Using MXCI Named Parameters
5-6
Using MXCI Unnamed Parameters
5-6
Using MXCI with SPJ RS
5-7
Invoking SPJs Statically in an Embedded SQL Program in C, C++, or COBOL
5-9
Invoking SPJs Dynamically in an Embedded SQL Program in C, C++, or
COBOL 5-10
Input and Output Descriptors
5-10
Argument Lists
5-13
Invoking SPJs in a NonStop ODBC/MX Client
5-14
Invoking SPJs in a JDBC/MX Program
5-15
6. Managing SPJs in NonStop SQL/MX
Granting Privileges for Invoking SPJs 6-1
Granting Privileges on an SPJ
6-1
Granting Privileges on Referenced Database Objects
6-3
Revoking Privileges on an SPJ 6-3
Displaying Information About SPJs 6-7
Listing the SPJs in a Catalog
6-7
Showing Privileges on the SPJs 6-8
Showing the Procedure Label 6-11
Showing the Syntax of an SPJ
6-12
Keeping SPJ Statements in OBEY Command Files 6-15
OBEY Command Files 6-15
Regenerating CREATE PROCEDURE Statements
6-17
Backing Up SPJs 6-19
Using SPJs in a Distributed Database Environment 6-19
Copying Java Classes to the Remote Node
6-20
Specifying the Node in the External Path 6-22
Distributing Application Classes 6-23
7. Performance and Troubleshooting
Troubleshooting SPJ Problems 7-1
Performance Tips 7-2
Displaying an Execution Plan for a CALL Statement
7-3
Using the DISPLAY_EXPLAIN Command 7-3
Using the EXPLAIN Function 7-3
Using the EXPLAIN function with SPJ RS 7-4