SQL/MX 3.2.1 Guide to Stored Procedures in Java (H06.26+, J06.15+)

EXTERNAL PATH '/usr/mydir/myclasses'
LANGUAGE JAVA
PARAMETER STYLE JAVA
READS SQL DATA;
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:default:connection");
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();
}
CREATE PROCEDURE Statement
CREATE PROCEDURE samdbcat.invent.supplierinfo(IN empnum NUMERIC(4),
OUT suppname CHAR(18),
OUT address CHAR(22),
OUT city CHAR(14),
OUT state CHAR(12),
OUT zipcode CHAR(10))
EXTERNAL NAME 'Inventory.supplierInfo'
EXTERNAL PATH '/usr/mydir/myclasses'
LANGUAGE JAVA
PARAMETER STYLE JAVA
READS SQL DATA;
Examples of the Sample SPJs 119