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

Index
Symbols
-Dsqlmx.udr.extensions option, 43
-Dsqlmx.udr.jrehome option, 40
A
ADJUSTSALARY procedure
creating, 18, 112, 118
invoking, 118
adjustSalary() method
code for, 110, 117
description of, 109
example of, 18
ALL_UIDS system metadata table, 22
Altering SPJs
altering, 68
Application class loader
See System class loader, 28
Application classes
description of, 30
in a distributed database environment, 100
Argument list, CALL statement, 73
Array, output parameter, 50
AUTOCOMMIT setting, 72
B
Backing up SPJs
backing up, 97
Bootstrap class loader, 28
C
CALL operator, 102
CALL statement
argument list, 73
description of, 72
dynamic execution, 77
execution plan, 102
restrictions, 71
shape, 103
static execution, 76
transaction behavior, 71
Calling SPJs
See Invoking SPJs, 71
Character sets, supported as SQL parameters
character sets, 63
Class file path, 66
Class loaders
copies of Java classes in, 31
description of, 28
in an SQL/MX UDR server process, 28
Class path, setting, 43
CLASSPATH environment variable, 45
COLS system metadata table, 22
Compilation, Java
compilation of, 58
Compressed Java signature, 65
CONTAINS SQL clause, 67
CONTROL QUERY SHAPE statement, 104
CREATE PROCEDURE statement, 96
description of, 59
examples of;, 111
createprocs.sql, 111
Creating SPJs, 21, 59
see also Registering SPJs[Creating SPJs:000]
D
DAILYORDERS procedure
creating, 112, 115
invoking, 115
Data types, 50, 62, 63
conversion of parameter arguments, 73
Database objects, referring to, 55
DISPLAY_EXPLAIN command, 102
Displaying information about SPJs
displaying information about, 88
Distributed database environment considerations, 98
DROP PROCEDURE statement, 68
Dropping SPJs, 67
Dynamic CALL statement, 77
argument lists, 79
E
EMPLOYEEJOB procedure
creating, 112, 118
invoking, 119
employeeJob() method
code for, 110, 118
description of, 109
Environment variables
CLASSPATH, 45
JREHOME, 40, 41
Error messages, finding, 101
Exceptions, handling, 57
EXECUTE privilege, 83
Execution plan, CALL statement, 102
EXPLAIN function, 102
Extension class loader, 28
Extension classes
description of, 28
required permissions, 48
External name
changes to, 69
description of, 64
External path
changes to, 68
description of, 66
specifying a remote node, 99
G
GRANT EXECUTE statement, 83
GRANT statement, 83
Grantee, displaying information about, 90
123