I'm having trouble getting results back from a stored procedure. This is the procedure:
CREATE PROCEDURE MYLIB/GETACCOUNT
( IN ACCOUNT CHAR(9), CUSTOMER CHAR(9) )
RESULT SETS 1
READS SQL DATA
CALL ON NULL INPUT
EXTERNAL NAME MYLIB/WEB100
PARAMETER STYLE SQL
$sql = "call mylib.getaccount(?,?)" ;
$stmt = db2_prepare($conn, $sql) ;
die("Could not prepare sql statment. ".db2_stmt_errormsg()."<br>");
db2_bind_param($stmt, 1, "acount", DB2_PARAM_IN) ;
db2_bind_param($stmt, 2, "customer", DB2_PARAM_OUT) ;
if (!$result = db2_execute($stmt))
die("Could not retrieve record. ".db2_stmt_errormsg()."<br>");
$row = db2_fetch_array($stmt) ;
I get no errors but the array is always blank. The procedure is supposed to return 7 fields : last name, first name, middle name, address, city, state, and zip.
I've tried 9 "?" in the call statement with DB2_PARAM_OUT statements and that did not work.
How do I get info back when it is a RESULT SET?