Neoview Guide to Stored Procedures in Java (R2.3, R2.4)

INOUT parameters, 65
INVENT schema
description of, 121
PARTLOC table, 124
PARTLOCS procedure, 106
PARTSUPP table, 122
SUPPLIER table, 121
SUPPLIERINFO procedure, 101
SUPPLYNUMBERS procedure, 104
Inventory class, 100
Invoking SPJs
description of, 63
examples of, 77
JDBC client application, 69
NCI, 66
ODBC client application, 68
privileges, 51
restrictions, 63
transaction behavior, 63
ISO88591, 46
J
JAR files
deleting on the Neoview platform, 41
downloading to a client workstation, 38
renaming on the Neoview platform, 39
uploading to the Neoview platform, 35
Java classes
accessible to an SPJ, 33
compilation of, 33
Java compilation, 33
Java data types, 26
Java Development Kit (JDK), required version, 23
Java exceptions, handling, 32
Java method (see SPJ method)
Java signature, restrictions, 25
Java variables, static, 29
java.sql.Types, 69
JDBC client application, invoking SPJs, 69
JDBC data types, 69
JDBC Type 4 driver (see Neoview JDBC Type 4 driver)
JDBC-based Java method, example of, 30
JDK, required version, 23
JOB table, 109
L
LOWERPRICE procedure
creating, 78
invoking, 79
lowerPrice() method
code for, 78
description of, 78
M
main() method, 29
MONTHLYORDERS procedure
creating, 82
invoking, 83
Multithreading, 64
N
Named parameter, 66
NCI, required version, 24
Neoview Command Interface (NCI)
calling SPJs, 66
displaying SPJs in a schema, 49
required version, 24
Neoview DB Admin (see DB Admin)
Neoview JDBC Type 4 driver, required version, 24
Neoview platform
deploying SPJ code onto, 35
required version, 23
Neoview Script (see Neoview Command Interface (NCI))
Nesting SPJs, 29
Null values, input and output, 29
numDailyOrders() method
code for, 80
description of, 80
numMonthlyOrders() method
code for, 82
description of, 82
O
OBEY command files (see Script files)
ODBC client application, invoking SPJs, 68
ODETAIL table, 118
ORDERS table, 117
ORDERSUMMARY procedure
creating, 91
invoking, 91
orderSummary() method
code for, 90
description of, 90
OUT parameters, 65
Output parameter array, 27
Output parameter, SPJ method, 26
P
Parameter arguments, 64, 65
Parameter array, 27
Parameters, SQL, 45
PARTDATA procedure
creating, 87
invoking, 88
partData() method
code for, 86
description of, 86
PARTLOC table, 124
partLocations() method
code for, 106
description of, 106
PARTLOCS procedure
creating, 106
invoking, 107
PARTS table, 120
PARTSUPP table, 122
Payroll class, 92
Performance tip, 73
PERSNL schema
128 Index