View Full Version : db2_execute errors

05-08-2009, 09:33 PM
Is there any good way to determine why something is failing other than a hit and miss approach? I am trying to execute the following code, and I am sure that the stored procedure works (I tested it using iSeries navigator). I have checked the parms again and again. The db2_prepare does not faile, nor do the db2_bind_param statements that precede the db2_execute fail.

Is there any error code reference anywhere?
I am not ever sure if this is an error code...

// Execute the stored procedure //
if ($stmt) {
$success = db2_execute($stmt);
if (!$success) {
$db2_error = db2_stmt_error($stmt);
echo "error code: $db2_error<br><br>";

Here is the result:
Warning: db2_execute() [function.db2-execute]: Statement Execute Failed in /www/zendcore/htdocs/is1015ra111.php on line 103
error code: 42724


05-11-2009, 08:08 PM
found the problem. just a library list issue.