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

3. Upload the SPJ JAR file from the client workstation to the Neoview platform. For details,
see Chapter 4 (page 35).
4. As the schema owner, create the SPJ in the Neoview database. For details, see Chapter 5
(page 43).
5. Grant privileges to roles for executing the SPJ and for operating on the referenced database
objects. For example, you can issue GRANT statements in an NCI session, as shown below,
or use the Grant/Revoke Privileges Tool in DB Admin:
GRANT EXECUTE
ON PROCEDURE persnl.adjustsalary
TO "ROLE.PAYROLLA", "ROLE.PAYROLLB"
WITH GRANT OPTION;
GRANT SELECT, UPDATE (salary)
ON TABLE persnl.employee
TO "ROLE.PAYROLLA", "ROLE.PAYROLLB"
WITH GRANT OPTION;
For details, see Chapter 6 (page 51).
6. Execute an SPJ by using a CALL statement in a client application. For example, you can
issue a CALL statement in an NCI session, as shown below, or in a JDBC or ODBC client
application:
SQL>call persnl.adjustsalary(29, 2.5, ?);
NEWSALARY
------------
139400.00
--- SQL operation complete.
For details, see Chapter 7 (page 63).
7. Monitor the performance of SPJs and resolve common problems with SPJs in a Neoview
database. See Chapter 8 (page 73).
22 Introduction