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-20
SUPPLIERINFO Stored Procedure
CALL Statement to Invoke the SPJ
To invoke the EMPLOYEEJOB procedure in MXCI:
CALL samdbcat.persnl.employeejob(337, ?);
The EMPLOYEEJOB procedure accepts the employee number 337 and returns this
output in MXCI:
JOBCODE
-----------
900
--- SQL operation complete.
The job code for employee number 337 is 900.
SUPPLIERINFO Stored Procedure
Java Method
public static void supplierInfo(BigDecimal suppNum,
String[] suppName,
String[] streetAddr,
String[] cityName,
String[] stateName,
String[] postCode)
throws SQLException
{
Connection conn = DriverManager.getConnection("jdbc:sqlmx:");
PreparedStatement getSupplier =
conn.prepareStatement("SELECT suppname, street, city, " +
" state, postcode " +
"FROM samdbcat.invent.supplier " +
"WHERE suppnum = ?");
getSupplier.setBigDecimal(1, suppNum);
ResultSet rs = getSupplier.executeQuery();
rs.next();
suppName[0] = rs.getString(1);
streetAddr[0] = rs.getString(2);
cityName[0] = rs.getString(3);
stateName[0] = rs.getString(4);
postCode[0] = rs.getString(5);
rs.close();
conn.close();
}