PHP : Function Reference : IBM DB2, Cloudscape and Apache Derby Functions : db2_next

Example 946. Calling a stored procedure that returns multiple result sets

In the following example, we call a stored procedure that returns three result sets. The first result set is fetched directly from the same statement resource on which we invoked the CALL statement, while the second and third result sets are fetched from statement resources returned from our calls to the db2_next_result() function.

copy to clipboard

<?php

$conn = db2_connect($database, $user, $password);


if ($conn) {

  $stmt = db2_exec($conn, 'CALL multiResults()');


  print "Fetching first result set\n";

  while ($row = db2_fetch_array($stmt)) {

    var_dump($row);

  }


  print "\nFetching second result set\n";

  $res = db2_next_result($stmt);

  if ($res) {

    while ($row = db2_fetch_array($res)) {

      var_dump($row);

    }

  }


  print "\nFetching third result set\n";

  $res2 = db2_next_result($stmt);

  if ($res2) {

    while ($row = db2_fetch_array($res2)) {

      var_dump($row);

    }

  }


  db2_close($conn);

}
?>

The above example will output:

copy to clipboard

Fetching first result set

array(2) {

  [0]=>

  string(16) "Bubbles         "

  [1]=>

  int(3)

}

array(2) {

  [0]=>

  string(16) "Gizmo           "

  [1]=>

  int(4)

}


Fetching second result set

array(4) {

  [0]=>

  string(16) "Sweater         "

  [1]=>

  int(6)

  [2]=>

  string(5) "llama"

  [3]=>

  string(6) "150.00"

}

array(4) {

  [0]=>

  string(16) "Smarty          "

  [1]=>

  int(2)

  [2]=>

  string(5) "horse"

  [3]=>

  string(6) "350.00"

}


Fetching third result set

array(1) {

  [0]=>

  string(16) "Bubbles         "

}

array(1) {

  [0]=>

  string(16) "Gizmo           "

}

db2_next_result

Requests the next result set from a stored procedure (PECL ibm_db2:1.0-1.6.2)
resource db2_next_result ( resource stmt )

Example 946. Calling a stored procedure that returns multiple result sets

Change Language

db2_next_result

Requests the next result set from a stored procedure (PECL ibm_db2:1.0-1.6.2) resource db2_next_result ( resource stmt )

Example 946. Calling a stored procedure that returns multiple result sets

Change Language

Requests the next result set from a stored procedure (PECL ibm_db2:1.0-1.6.2)
resource db2_next_result ( resource stmt )