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

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 a Neoview Script 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 a Neoview Script 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