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

Granting privileges on an SPJ, 83
Grantor, displaying information about, 90
I
IN parameter mode, 61
IN parameters, 73
Initialization, SPJ environment, 26
INOUT parameter mode, 61
INOUT parameters, 74
Input descriptors
input and output descriptors, 77
Internal SPJ, registering an SPJ, 21
Internal type signature
Compressed Java signature, 65
Inventory class, 110
Invoking SPJs
description of, 71
embedded SQL program in C, C++, or COBOL, 76,
77
examples of, 113
internal process, 22
JDBC/MX program, 81
MXCI, 74
ODBC/MX client, 80
privileges, 83
restrictions, 71
transaction behavior, 71
J
JAR file path, 66
JAR files, installing, 46
Java classes, 58
accessible to an SPJ, 29
altering, 68
copying to a remote node, 98
effects of changes to, 30
loading, 28
Java compilation, 58
Java data types
Java, 50, 63
Java environment
SPJ environment, 24
Java exceptions, handling, 57
Java library path for SPJs, 35
Java method
SPJ method, 49
Java security, 46
Java signature
changes to, 70
compressed, 65
description of, 64
restrictions, 49
Java variables, static, 52
Java virtual machine (JVM)
invoking an SPJ, 22
registering an SPJ, 21
java.sql.Types, 81
JDBC data types, 81
JDBC Driver for SQL/MX
See JDBC/MX driver, 33
JDBC/MX driver
description of, 33
required permissions, 48
verifying the version, 34
JDBC/MX JAR file, 36
JDBC/MX location, setting, 42
JDBC/MX native library, 35
JDBC/MX-based Java method, 24
see also SPJ method[JDBC/MX method:000]
example of, 54
processing, 24
jdbcMx.jar file, 36
jdbcmx.transactionMode property, 72
JREHOME location
environment variable, 41
setting, 35, 40
JVM startup options, setting;SPJ environment
configuring, 36
L
libjdbcMx.so library, 35
LOCATION clause, 67
LOWERPRICE procedure
creating, 114
invoking, 114
lowerPrice() method
code for, 108, 113
description of, 107
M
main() method, 52
Method attributes, 59
MODIFIES SQL DATA clause, 67
MONTHLYORDERS procedure
creating, 112, 116
invoking, 116
Multithreading, 27
MXCMP process, registering an SPJ, 21
MXUDR
SQL/MX UDR server, 23
N
Named parameter, 75
Nesting SPJs, 53
NO SQL clause, 67
Nonblocking JDBC/MX, 27
NonStop Server for Java
description of, 33
specifying for SPJs, 35
verifying the version, 34
Nowait SQL/MX
Nonblocking JDBC/MX, 27
Nulls, input and output, 52
numDailyOrders() method
code for, 108, 115
description of, 107
numMonthlyOrders() method
code for, 108, 115
124 Index