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

Index
A
ADJUSTSALARY procedure
creating, 91
invoking, 92
adjustSalary() method
code for, 30, 91
description of, 91
example of, 21
Altering SPJs, 50
Application classes, accessible to an SPJ, 32
Arguments, CALL statement
input types
arithmetic expression, 65
concatenation operation, 65
dynamic parameter, 65
literal, 65
scalar subquery, 65
SQL function, 65
list, 64
output types
dynamic parameter, 65
named parameter, 65
unnamed parameter, 65
Array, output parameter, 26
C
CALL statement
argument list, 64
argument types
arithmetic expression, 65
concatenation operation, 65
dynamic parameter, 65
literal, 65
scalar subquery, 65
SQL function, 65
description of, 64
restrictions, 63
transaction behavior, 63
Calling SPJs (see Invoking SPJs)
Client applications, calling SPJs, 20, 68, 69
Compilation, Java, 33
Compound statement, 63
Connection objects, 29
Create Procedure Wizard, 43
Creating SPJs
description of, 43
examples of, 75
privileges, 43
CUSTOMER table, 114
D
DAILYORDERS procedure
creating, 78
invoking, 79
Dangling reference, stored procedures, 39, 41
Data source URL, 29
Data types
conversion of parameter arguments, 64
Java, 26
SQL, 26
Database objects, referring to, 31
Database, sample, 107
DB Admin
creating SPJs, 43
deleting SPJ JAR files, 41
displaying SPJs in a schema, 47
downloading SPJ JAR files, 38
dropping SPJs, 49
granting privileges, 54
renaming SPJ JAR files, 39
required version, 23
revoking privileges, 57
showing privileges, 60
uploading SPJ JAR files, 35
Default connection, 29
DEPT table, 109
Displaying SPJs
using DB Admin, 47
using Neoview Script, 49
Documents, related information, 15
Dropping SPJs, 49
E
EMPLOYEE table, 107
EMPLOYEEJOB procedure
creating, 93
invoking, 93
employeeJob() method
code for, 93
description of, 93
Error messages, finding, 73
Exceptions, handling, 32
EXECUTE privilege, 51
G
GRANT EXECUTE statement, 51
GRANT statement, 51
Grant/Revoke Privileges Tool, 55
I
IN parameters, 65
INOUT parameters, 65
INVENT schema
description of, 119
PARTLOC table, 122
PARTLOCS procedure, 104
PARTSUPP table, 120
SUPPLIER table, 119
SUPPLIERINFO procedure, 99
SUPPLYNUMBERS procedure, 102
Inventory class, 98
125