(PECL ibm_db2 >= 1.0.0) Set options for connection or statement resources bool db2_set_option ( resource $resource, array $options, int $type ) Sets options for a statement resource or a connection resource. You cannot set options for result set resources. Parameters: resource A valid statement resource as returned from db2_prepare() or a valid connection resource as r

(PECL ibm_db2 >= 1.0.0) Returns a single column from a row in the result set mixed db2_result ( resource $stmt, mixed $column ) Use db2_result() to return the value of a specified column in the current row of a result set. You must call db2_fetch_row() before calling db2_result() to set the location of the result set pointer. Parameters: stmt A valid stmt resource.

(PECL ibm_db2 >= 1.1.1) Returns an object with properties that describe the DB2 database server object db2_server_info ( resource $connection ) This function returns an object with read-only properties that return information about the IBM DB2, Cloudscape, or Apache Derby database server. The following table lists the database server properties: Database server properties Property name Return type Description DBMS_NAME s

(PECL ibm_db2 >= 1.0.0) Rolls back a transaction bool db2_rollback ( resource $connection ) Rolls back an in-progress transaction on the specified connection resource and begins a new transaction. PHP applications normally default to AUTOCOMMIT mode, so db2_rollback() normally has no effect unless AUTOCOMMIT has been turned off for the connection resource. Parameters: connection

(PECL ibm_db2 >= 1.0.0) Prepares an SQL statement to be executed resource db2_prepare ( resource $connection, string $statement [, array $options ] ) db2_prepare() creates a prepared SQL statement which can include 0 or more parameter markers (? characters) representing parameters for input, output, or input/output. You can pass parameters to the prepared statement using db2_bind_param(), or for input values only, as an

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

(PECL ibm_db2 >= 1.0.0) Returns a result set listing the stored procedures registered in a database resource db2_procedures ( resource $connection, string $qualifier, string $schema, string $procedure ) Returns a result set listing the stored procedures registered in a database. Parameters: connection A valid connection to an IBM DB2, Cloudscape, or Apache Derby data

(PECL ibm_db2 >= 1.0.0) Returns a result set listing stored procedure parameters resource db2_procedure_columns ( resource $connection, string $qualifier, string $schema, string $procedure, string $parameter ) Returns a result set listing the parameters for one or more stored procedures. Parameters: connection A valid connection to an IBM DB2, Cloudscape, or Apache D

(PECL ibm_db2 >= 1.0.0) Returns the number of fields contained in a result set int db2_num_fields ( resource $stmt ) Returns the number of fields contained in a result set. This is most useful for handling the result sets returned by dynamically generated queries, or for result sets returned by stored procedures, where your application cannot otherwise know how to retrieve and use the results. Parameter

(PECL ibm_db2 >= 1.0.0) Returns a persistent connection to a database resource db2_pconnect ( string $database, string $username, string $password [, array $options ] ) Returns a persistent connection to an IBM DB2 Universal Database, IBM Cloudscape, or Apache Derby database. For more information on persistent connections, refer to Persistent Database Connections. Calling db2_close() on a persistent connection alway