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

ADJUSTSALARY procedure, 93
DEPT table, 111
description of, 109
EMPLOYEE table, 109
EMPLOYEEJOB procedure, 95
JOB table, 109
PROJECT table, 113
PROJECTTEAM procedure, 97
TOPSALESREPS procedure, 98
Privileges
for creating SPJs, 43
for invoking SPJs, 51
granting, 51
on referenced database objects, 52
revoking, 52
showing in DB Admin, 60
Procedure Code Files Tool, 35
PROJECT table, 113
PROJECTTEAM procedure
creating, 97
invoking, 97
projectTeam() method
code for, 97
description of, 97
R
registerOutParameter() method, 69
Required software, 23
Result sets
coding in a Java method, 27
not specifying in a CALL statement, 66
returning in JDBC client applications, 69
returning in NCI, 67
returning in ODBC client applications, 68
REVOKE EXECUTE statement, 52
REVOKE statement, 52
Rowsets, 63
S
Sales class, 77
SALES schema
CUSTOMER table, 116
DAILYORDERS procedure, 80
description of, 116
LOWERPRICE procedure, 78
MONTHLYORDERS procedure, 82
ODETAIL table, 118
ORDERS table, 117
ORDERSUMMARY procedure, 90
PARTDATA procedure, 86
PARTS table, 120
TOTALPRICE procedure, 84
Sample database, 109
Script files, 53
SHOW PROCEDURES command, example of, 49
Software, required, 23
SPJ (see Stored procedure in Java (SPJ))
SPJ JAR files (see JAR files)
SPJ method
accessing a Neoview database, 29
coding guidelines, 25
examples of, 77
referring to database objects, 31
returning output values, 26
returning result sets, 27
signature restrictions, 25
SQL data types, 26
SQL database objects, referring to, 31
SQL parameters, 64
SQLException, 32
sqlj.defaultconnection system property, 30
Static Java variables, 29
Stored procedure in Java (SPJ)
altering, 50
argument list, 64
benefits of, 19
creating, 43
description of, 19
displaying
in DB Admin, 47
in NCI, 49
dropping, 49
examples of, 77
granting privileges on, 51
invoking, 63
revoking privileges from, 52
steps for using, 21
Stored procedure result set, 27
SUPPLIER table, 121
SUPPLIERINFO procedure
creating, 101
invoking, 103
supplierInfo() method
code for, 101
description of, 101
SUPPLYNUMBERS procedure
creating, 104
invoking, 105
supplyQuantities() method
code for, 104
description of, 104
T
throw statement, 33
TOPSALESREPS procedure
creating, 98
invoking, 99
topSalesReps() method
code for, 98
description of, 98
TOTALPRICE procedure
creating, 84
invoking, 85
totalPrice() method
code for, 84
description of, 84
Transaction behavior, 63
Triggers, 63, 70
129