Neoview Guide to Stored Procedures in Java (R2.5)

I
IN parameters, 53
INOUT parameters, 53
INVENT schema
description of, 113
PARTLOC table, 116
PARTLOCS procedure, 99
PARTSUPP table, 114
SUPPLIER table, 113
SUPPLIERINFO procedure, 94
SUPPLYNUMBERS procedure, 97
Inventory class, 92
Invoking SPJs
description of, 51
examples of, 65
JDBC client application, 57
NCI, 54
ODBC client application, 56
privileges, 47
restrictions, 51
transaction behavior, 51
ISO88591, 38
J
JAR file
deleting, 35
downloading, 34
renaming, 34
uploading, 33
Java classes
accessible to an SPJ, 31
compilation of, 31
Java compilation, 31
Java data types, 24
Java Development Kit (JDK), required version, 21
Java exceptions, handling, 31
Java method (see SPJ method)
Java signature, restrictions, 23
Java variables, static, 27
java.sql.Types, 57
JDBC client application, invoking SPJs, 57
JDBC data types, 57
JDBC Type 4 driver (see Neoview JDBC Type 4 driver)
JDBC-based Java method, example of, 29
JDK, required version, 21
JOB table, 101
L
LOWERPRICE procedure
creating, 69
invoking, 70
lowerPrice() method
code for, 69
description of, 69
M
main() method, 27
MONTHLYORDERS procedure
creating, 73
invoking, 74
Multithreading, 52
N
Named parameter, 54
NCI, required version, 22
Neoview Command Interface (NCI)
calling SPJs, 54
displaying SPJs in a schema, 44
required version, 22
Neoview JDBC Type 4 driver, required version, 22
Neoview platform
deploying SPJ code onto, 33, 37
required version, 21
Neoview Script (see Neoview Command Interface (NCI))
Nesting SPJs, 27
Null values, input and output, 27
numDailyOrders() method
code for, 71
description of, 71
numMonthlyOrders() method
code for, 73
description of, 73
O
OBEY command files (see Script files)
ODBC client application, invoking SPJs, 56
ODETAIL table, 110
ORDERS table, 109
ORDERSUMMARY procedure
creating, 82
invoking, 82
orderSummary() method
code for, 81
description of, 81
OUT parameters, 53
Output parameter array, 25
Output parameter, SPJ method, 24
P
Parameter arguments, 52, 53
Parameter array, 25
Parameters tab, procedures, 43
Parameters, SQL, 38, 39
PARTDATA procedure
creating, 78
invoking, 79
partData() method
code for, 77
description of, 77
PARTLOC table, 116
partLocations() method
code for, 99
description of, 99
PARTLOCS procedure
creating, 99
invoking, 100
PARTS table, 112
PARTSUPP table, 114
120 Index