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

Contents

HP NonStop SQL/MX Guide to Stored Procedures in Java—523727-004

5. Invoking SPJs in NonStop SQL/MX (continued)

Using the CALL Statement 5-3

Specifying the Name of the SPJ 5-3

Listing the Arguments of the SPJ 5-4

Invoking SPJs in MXCI 5-6

Using MXCI Named Parameters 5-6

Using MXCI Unnamed Parameters 5-6

Invoking SPJs Statically in an Embedded SQL Program in C, C++, or COBOL 5-8

Invoking SPJs Dynamically in an Embedded SQL Program in C, C++, or COBOL 5-9

Input and Output Descriptors 5-9

Argument Lists 5-12

Invoking SPJs in a NonStop ODBC/MX Client 5-13

Invoking SPJs in a JDBC/MX Program 5-14

Invoking SPJs in an SQLJ 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-4

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-14

OBEY Command Files 6-14

Regenerating CREATE PROCEDURE Statements 6-16

Backing Up SPJs 6-18

Using SPJs in a Distributed Database Environment 6-18

Copying Java Classes to the Remote Node 6-19

Specifying the Node in the External Path 6-21

Distributing Application Classes 6-22

Migrating SPJs From NonStop SQL/MX Release 1.8 to NonStop SQL/MX Release

2.x 6-22