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

HP NonStop SQL/MX Guide to Stored Procedures in Java—540433-003
Index-1
Index
A
ADJUSTSALARY procedure
creating 1-3, A-11, A-18
invoking A-19
adjustSalary() method
code for 3-8, A-7, A-18
description of A-7
example of 1-2
ALL_UIDS system metadata table 1-7
Altering SPJs 4-14
Application class loader
See System class loader
Application classes
description of 1-17
in a distributed database
environment 6-23
Argument list, CALL statement 5-4
Array, output parameter 3-3
AUTOCOMMIT setting 5-2
B
Backing up SPJs 6-19
Bootstrap class loader 1-15
C
CALL operator 7-3
CALL statement
argument list 5-4
description of 5-3
dynamic execution 5-10
execution plan 7-3
restrictions 5-1
shape 7-5
static execution 5-9
transaction behavior 5-2
Calling SPJs
See Invoking SPJs
Character sets, supported as SQL
parameters 4-6
Class file path 4-10
Class loaders
copies of Java classes in 1-19
description of 1-15
in an SQL/MX UDR server
process 1-16
Class path, setting 2-18
CLASSPATH environment variable 2-20
COLS system metadata table 1-7
Compilation, Java 3-14
Compressed Java signature 4-10
Connection objects 3-7
CONTAINS SQL clause 4-12
CONTROL QUERY SHAPE statement 7-5
CREATE PROCEDURE statement
description of 4-2
examples of A-11
regenerating 6-17
createprocs.sql A-11
Creating SPJs 1-6, 4-1
See also Registering SPJs
D
DAILYORDERS procedure
creating A-11, A-15
invoking A-15
Data types
conversion of parameter arguments 5-4
Java 3-2, 4-6
SQL 4-5
Database objects, referring to 3-8
Displaying information about SPJs 6-7
DISPLAY_EXPLAIN command 7-3
Distributed database environment
considerations 6-19
DROP PROCEDURE statement 4-13
Dropping SPJs 4-13