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

HP NonStop SQL/MX Guide to Stored Procedures in Java—523727-004
Index-1
Index
A
ADJUSTSALARY procedure
creating 1-3, A-11, A-18
invoking A-19
adjustSalary() method
code for 3-6, A-7, A-18
description of A-7
example of 1-2
ALL_UIDS system metadata table 1-7
Altering SPJs 4-13
Application class loader
See System class loader
Application classes
description of 1-17
in a distributed database
environment 6-22
Argument list, CALL statement 5-4
Array, output parameter 3-3
AUTOCOMMIT setting 5-2
B
Backing up SPJs 6-18
Bootstrap class loader 1-15
C
CALL operator 7-3
CALL statement
argument list 5-4
description of 5-3
dynamic execution 5-9
execution plan 7-3
restrictions 5-1
shape 7-4
static execution 5-8
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-22
CLASSPATH environment variable 2-24
COLS system metadata table 1-7
Compilation, Java 3-13
Compressed Java signature 4-9
Connection objects 3-5
CONTAINS SQL clause 4-11
CONTROL QUERY SHAPE statement 7-4
CREATE PROCEDURE statement
description of 4-2
examples of A-11
regenerating 6-16
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 source URL 3-6
Data types
conversion of parameter arguments 5-4
Java 3-2, 4-6
SQL 4-5
Database objects, referring to 3-8
Default connection 3-5
Displaying information about SPJs 6-7
DISPLAY_EXPLAIN command 7-3
Distributed database environment
considerations 6-18