SQL/MX 3.2.1 Guide to Stored Procedures in Java (H06.26+, J06.15+)

description of, 107
O
OBEY command files, 94
OBJECTS system metadata table, 22
ODBC/MX client
invoking SPJs, 80
setting JREHOME, 40
setting the class path, 44
OUT parameter mode, 61
OUT parameters, 74
Output descriptors, 77
Output parameter array, 50
Output parameter, SPJ method, 50
Overloading of procedure names
overloading of, 61
Ownership, displaying information about, 90
P
Parameter array, 50
Parameter descriptors, retrieving information about, 79
Parameter mode, IN, OUT, or INOUT, 61
Parameters, SQL
See SQL parameters, 73
SQL parameters, 61
Payroll class, 109
Performance tips, 101
Privileges
displaying information about, 89
for creating SPJs, 59
for dropping SPJs, 67
for invoking SPJs, 83
granting, 83
on referenced database objects, 84
revoking, 85
Procedure label
creation of, 22
effect of creating an SPJ, 59
effect of dropping an SPJ, 67
naming, 66
showing the location, 91
Procedure names, 61
description of, 60
Pure Java method, 23
see also SPJ method
R
READS SQL DATA clause, 67
Regenerating CREATE PROCEDURE statements
regenerating, 96
Registering SPJs, 21
see also Creating SPJs[Registering SPJs:000]
registerOutParameter() method, 81
Reinitialization, SPJ environment, 27
Remote node
copying Java classes to, 98
specifying in the external path, 99
REPLICAS system metadata table, 22
Requirements, software, 32
Result set, 51
REVOKE EXECUTE statement, 85
REVOKE statement, 85
Revoking privileges from an SPJ, 85
ROUTINES system metadata table, 22
Rowsets, 71
S
Sales class, 107
Sample SPJs, installing, 105
SampleSPJs.jar, 105
Security, SPJ environment, 46
Shape, for a CALL statement, 103
SHOWDDL command, 92
SHOWSHAPE command, 103
Signature, Java see Java signature
Software product versions
description of, 32
verification of, 33
Software requirements, 32
SPJ
See Stored procedure in Java (SPJ), 17
SPJ class loader, 28
see also Class loaders[SPJ class loader:000]
SPJ classes see Java classes
SPJ environment
description of, 24
diagram of, 24
initialization, 26
reinitialization, 27
security, 46
SPJ method, 53, 57
see also JDBC/MX-based Java method
see also Pure Java method
see also SQLJ-based Java method
accessing SQL/MP and SQL/MX databases, 53
examples of, 106
external path, 66
guidelines for writing, 49
naming in a CREATE PROCEDURE statement, 64
referring to database objects, 55
required permissions, 48
signature in a CREATE PROCEDURE statement, 64
signature restrictions, 49
types of, 23, 53
SPJ policy file; mxlangman policy file;Policy file, 47
SQL access modes, 67
SQL data types
SQL, 62
SQL parameters, 63
in a CALL statement, 73
in a CREATE PROCEDURE statement, 61
SQL syntax, SPJ, 92
SQL/MP database objects, referring to, 55
SQL/MX data types, 50, 63
SQL/MX database objects, referring to, 55
SQL/MX language manager, required permissions, 47
SQL/MX UDR server
accessing Java classes, 29
125