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

Index
HP NonStop SQL/MX Guide to Stored Procedures in Java—523727-004
Index-6
T
SQL/MX UDR server (continued)
registering an SPJ 1-7
relinking of 2-5
server process 1-12
verifying the version 2-3
Static CALL statement 5-8
Static Java variables 3-5
Stored procedure in Java (SPJ)
altering 4-13
argument list 5-4
backing up 6-18
benefits of 1-4
description of 1-1
displaying information about 6-7
granting privileges on 6-1
invoking 1-8, 5-1
migrating from Release 1.8 to 2.x 6-22
naming 4-2
registering 1-6, 4-1
revoking privileges from 6-4
SQL/MX processing of 1-6/1-9
steps for using 1-2
syntax 6-12
Stored procedure result set 3-4
SUPPLIERINFO procedure
creating A-12, A-21
invoking A-21
supplierInfo() method
code for A-9
, A-20
description of A-9
SUPPLYNUMBERS procedure
creating A-12, A-22
invoking A-22
supplyQuantities() method
code for A-10, A-21
description of A-9
Surrogate file
See Procedure label
Syntax, SPJ 6-12
System class loader 1-15
System classes
description of 1-15
required permissions 2-28
System.err.println() method 3-11
System.out.println() method 3-11
SYSTEM_SQLJ_SCHEMA schema 1-7
T
TBL_PRIVILEGES system metadata
table 1-7
TEXT system metadata table 1-7
throw statement 3-11
TOTALPRICE procedure
creating A-11, A-17
invoking A-17
totalPrice() method
code for A-6, A-17
description of A-3
Transaction behavior 5-2
transactionMode property 5-3
Triggers 5-1
Troubleshooting guidelines 7-1
Types data types 5-14
U
UDR extensions class path 2-20
UDR_JAVA_OPTIONS default attribute
description of 2-11
multiple settings 2-15
performance considerations 2-16
setting in a CONTROL QUERY
DEFAULT statement 2-12
setting in the SYSTEM_DEFAULTS
table 2-11
unique settings 2-15
Unnamed parameter 5-6
User-defined exceptions 3-11