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

(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