(PECL ibm_db2 >= 1.0.0) Returns the number of rows affected by an SQL statement int db2_num_rows ( resource $stmt ) Returns the number of rows deleted, inserted, or updated by an SQL statement. To determine the number of rows that will be returned by a SELECT statement, issue SELECT COUNT(*) with the same predicates as your intended SELECT statement and retrieve the value. If your application logic checks the number

(PECL ibm_db2 >= 1.8.0) Closes a persistent database connection bool db2_pclose ( resource $resource ) This function closes a DB2 client connection created with db2_pconnect() and returns the corresponding resources to the database server. Note: This function is only available on i5/OS in response to i5/OS system administration requests. If you have a persistent DB2 client connection created with db2_pconnect(), yo

(PECL ibm_db2 >= 1.0.0) Frees resources associated with a result set bool db2_free_result ( resource $stmt ) Frees the system and database resources that are associated with a result set. These resources are freed implicitly when a script finishes, but you can call db2_free_result() to explicitly free the result set resources before the end of the script. Parameters: stmt

(PECL ibm_db2 >= 1.6.0) Retrieves an option value for a statement resource or a connection resource string db2_get_option ( resource $resource, string $option ) Retrieves the value of a specified option value for a statement resource or a connection resource. Parameters: resource A valid statement resource as returned from db2_prepare() or a valid connection resource a

(PECL ibm_db2 >= 1.6.0) Gets a user defined size of LOB files with each invocation string db2_lob_read ( resource $stmt, int $colnum, int $length ) Use db2_lob_read() to iterate through a specified column of a result set and retrieve a user defined size of LOB data. Parameters: stmt A valid stmt resource containing LOB data. colnum

(PECL ibm_db2 >= 1.0.0) Frees resources associated with the indicated statement resource bool db2_free_stmt ( resource $stmt ) Frees the system and database resources that are associated with a statement resource. These resources are freed implicitly when a script finishes, but you can call db2_free_stmt() to explicitly free the statement resources before the end of the script. Parameters:

(PECL ibm_db2 >= 1.7.1) Returns the auto generated ID of the last insert query that successfully executed on this connection string db2_last_insert_id ( resource $resource ) Returns the auto generated ID of the last insert query that successfully executed on this connection. The result of this function is not affected by any of the following: A single row INSERT statement with a VALUES clause for a table without an i

(PECL ibm_db2 >= 1.0.0) Requests the next result set from a stored procedure resource db2_next_result ( resource $stmt ) 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

(PECL ibm_db2 >= 1.0.0) Returns a result set listing the foreign keys for a table resource db2_foreign_keys ( resource $connection, string $qualifier, string $schema, string $table-name ) Returns a result set listing the foreign keys for a table. Parameters: connection A valid connection to an IBM DB2, Cloudscape, or Apache Derby database. qual

(PECL ibm_db2 >= 1.0.0) Returns the position of the named column in a result set int db2_field_num ( resource $stmt, mixed $column ) Returns the position of the named column in a result set. Parameters: stmt Specifies a statement resource containing a result set. column Specifies the column in the result set. This can either be an