SQL/MX Guide to Stored Procedures in Java (G06.24+, H06.03+)

Sample SPJs
HP NonStop SQL/MX Guide to Stored Procedures in Java—523727-004
A-2
Installing the SQL/MX Sample Database
For details of these steps, see the README file in SampleSPJs.jar.
Figure A-1. Steps for Using Sample SPJs
OBEY createprocs.sql;
Register the
stored procedures
in NonStop
SQL/MX.
GRANT EXECUTE
ON monthlyorders
TO PUBLIC;
GRANT SELECT
ON TABLE orders
TO PUBLIC;
Grant privileges
for invoking
the stored
procedures.
CALL monthlyorders(3,?);
Call the stored
procedures.
VST023.vsd
Extract the
source files in
OSS.
Verify and
configure your
system
environment.
Compile the
source files.
! NonStop SQL/MX
! NonStop Server for Java
! JDBC/MX driver
! Sample database (T0517)
jar xf SampleSPJs.jar
javac Sales.java...
Download the
JAR file from
NTL to your PC.
View the
README file on
your PC.
Upload the JAR
file to OSS.
NonStop
OSS
PC
PC
NTL
PC