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

Payroll class, 83
Performance tip, 62
PERSNL schema
ADJUSTSALARY procedure, 85
DEPT table, 103
description of, 101
EMPLOYEE table, 101
EMPLOYEEJOB procedure, 87
JOB table, 101
PROJECT table, 105
PROJECTTEAM procedure, 89
TOPSALESREPS procedure, 90
Privileges
displaying for procedures, 43
for creating SPJs, 37
for invoking SPJs, 47
granting, 47
on referenced database objects, 48
revoking, 48
Privileges tab, procedures, 43
Procedure Code File Tool
deleting a JAR, 35
downloading a JAR, 34
renaming a JAR, 34
uploading a JAR, 33
Procedures
attributes tab, 42
creating, 37
displaying, 41
dropping, 40
parameters tab, 43
privileges tab, 43
Usage tab, 43
PROJECT table, 105
PROJECTTEAM procedure
creating, 89
invoking, 89
projectTeam() method
code for, 89
description of, 89
R
registerOutParameter() method, 57
Required software, 21
Result sets
coding in a Java method, 25
not specifying in a CALL statement, 54
returning in JDBC client applications, 58
returning in NCI, 55
returning in ODBC client applications, 56
REVOKE EXECUTE statement, 48
REVOKE statement, 48
Rowsets, 51
S
Sales class, 65
SALES schema
CUSTOMER table, 108
DAILYORDERS procedure, 71
description of, 108
LOWERPRICE procedure, 69
MONTHLYORDERS procedure, 73
ODETAIL table, 110
ORDERS table, 109
ORDERSUMMARY procedure, 81
PARTDATA procedure, 77
PARTS table, 112
TOTALPRICE procedure, 75
Sample database, 101
Script files, 49
SHOW PROCEDURES command, example of, 44
Software, required, 21
SPJ (see Stored procedure in Java (SPJ))
SPJ JAR files (see JAR files)
SPJ method
accessing a Neoview database, 28
coding guidelines, 23
examples of, 65
referring to database objects, 30
returning output values, 24
returning result sets, 25
signature restrictions, 23
SQL data types, 24
SQL database objects, referring to, 30
SQL parameters, 52
SQLException, 31
sqlj.defaultconnection system property, 28
Static Java variables, 27
Stored procedure in Java (SPJ)
altering, 44
argument list, 52
benefits of, 17
creating, 37
description of, 17
displaying
in HPDM, 41
in NCI, 44
dropping, 40
examples of, 65
granting privileges on, 47
invoking, 51
revoking privileges from, 48
steps for using, 19
Stored procedure result set, 25
SUPPLIER table, 113
SUPPLIERINFO procedure
creating, 94
invoking, 96
supplierInfo() method
code for, 94
description of, 94
SUPPLYNUMBERS procedure
creating, 97
invoking, 98
supplyQuantities() method
code for, 97
description of, 97
121