db2_next_result()

db2_next_result - Requests the next result set from a stored procedure

Syntax

resource db2_next_result (resource $stmt)

Arguments

• stmt - A prepared statement returned from db2_exec() or db2_execute().

Description

A stored procedure can return zero or more result sets. While you handle the first result set in exactly the same way you would handle the results returned by a simple SELECT statement, to fetch the second and subsequent result sets from a stored procedure you must call the db2_next_result() function and return the result to a uniquely named PHP variable.

Version

PHP PECL ibm_db2 >= 1.0.0

Return value

Returns a new statement resource containing the next result set if the stored procedure returned another result set. Returns FALSE if the stored procedure did not return another result set.