Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    Regular Coder
    Join Date
    Feb 2005
    Location
    Atlanta, GA
    Posts
    171
    Thanks
    5
    Thanked 0 Times in 0 Posts

    db2_execute errors

    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...

    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

    Thanks!

  • #2
    Regular Coder
    Join Date
    Feb 2005
    Location
    Atlanta, GA
    Posts
    171
    Thanks
    5
    Thanked 0 Times in 0 Posts
    found the problem. just a library list issue.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •