SQL/MX 3.2 Guide to Stored Procedures in Java (H06.25+, J06.14+)

Index
HP NonStop SQL/MX Release 3.2 Guide to Stored Procedures in Java691166-001
Index-4
O
numMonthlyOrders() method
code for A-5, A-16
description of A-3
O
OBEY command files 6-14
OBJECTS system metadata table 1-7
ODBC/MX client
invoking SPJs 5-13
setting JREHOME 2-12
setting the class path 2-17
OUT parameter mode 4-4
OUT parameters 5-5
Output descriptors 5-9
Output parameter array 3-3
Output parameter, SPJ method 3-2
Overloading of procedure names 4-3
Ownership, displaying information
about 6-9
P
Parameter array 3-3
Parameter descriptors, retrieving
information about 5-12
Parameter mode, IN, OUT, or INOUT 4-4
Parameters, SQL
See SQL parameters
Payroll class A-7
Performance tips 7-2
Policy file 2-22
Privileges
displaying information about 6-8
for creating SPJs 4-1
for dropping SPJs 4-12
for invoking SPJs 6-1
granting 6-1
on referenced database objects 6-3
revoking 6-3
Procedure label
creation of 1-7
Procedure label (continued)
effect of creating an SPJ 4-1
effect of dropping an SPJ 4-12
naming 4-10
showing the location 6-11
Procedure names
description of 4-2
overloading of 4-3
Pure Java method 1-9
See also SPJ method
R
READS SQL DATA clause 4-11
Regenerating CREATE PROCEDURE
statements 6-16
Registering SPJs 1-6
See also Creating SPJs
registerOutParameter() method 5-14
Reinitialization, SPJ environment 1-13
Remote node
copying Java classes to 6-19
specifying in the external path 6-21
REPLICAS system metadata table 1-7
Requirements, software 2-1
Result set 3-4
REVOKE EXECUTE statement 6-3
REVOKE statement 6-3
Revoking privileges from an SPJ 6-3
ROUTINES system metadata table 1-7
Rowsets 5-1
S
Sales class A-3
Sample SPJs, installing A-1
SampleSPJs.jar A-1
Security, SPJ environment 2-21
Shape, for a CALL statement 7-4
SHOWDDL command 6-12
SHOWSHAPE command 7-4