(PECL ibm_db2 >= 1.0.0) Returns a connection to a database resource db2_connect ( string $database, string $username, string $password [, array $options ] ) Creates a new connection to an IBM DB2 Universal Database, IBM Cloudscape, or Apache Derby database. Parameters: database For a cataloged connection to a database, database represents the database alias in the DB

(PECL ibm_db2 >= 1.0.0) Returns the cursor type used by a statement resource int db2_cursor_type ( resource $stmt ) Returns the cursor type used by a statement resource. Use this to determine if you are working with a forward-only cursor or scrollable cursor. Parameters: stmt A valid statement resource. Returns: Returns either DB2_FORWARD_ON

(PECL ibm_db2 >= 1.0.1) Returns an array, indexed by column position, representing a row in a result set array db2_fetch_array ( resource $stmt [, int $row_number = -1 ] ) Returns an array, indexed by column position, representing a row in a result set. The columns are 0-indexed. Parameters: stmt A valid stmt resource containing a result set.

(PECL ibm_db2 >= 1.0.0) Executes an SQL statement directly resource db2_exec ( resource $connection, string $statement [, array $options ] ) Executes an SQL statement directly. If you plan to interpolate PHP variables into the SQL statement, understand that this is one of the more common security exposures. Consider calling db2_prepare() to prepare an SQL statement with parameter markers for input values. Then you can

(PECL ibm_db2 >= 1.0.0) Executes a prepared SQL statement bool db2_execute ( resource $stmt [, array $parameters ] ) db2_execute() executes an SQL statement that was prepared by db2_prepare(). If the SQL statement returns a result set, for example, a SELECT statement or a CALL to a stored procedure that returns one or more result sets, you can retrieve a row as an array from the stmt resource using db2_fetch_assoc(),

(PECL ibm_db2 >= 1.6.0) Used to escape certain characters string db2_escape_string ( string $string_literal ) Prepends backslashes to special characters in the string argument. Parameters: string_literal The string that contains special characters that need to be modified. Characters that are prepended with a backslash are \x00, \n, \r, \, ', " and \x1a.

(PECL ibm_db2 >= 1.0.0) Returns a result set listing the columns and associated metadata for a table resource db2_columns ( resource $connection [, string $qualifier [, string $schema [, string $table-name [, string $column-name ]]]] ) Returns a result set listing the columns and associated metadata for a table. Parameters: connection A valid connection to an IBM DB2

(PECL ibm_db2 >= 1.0.0) Returns a string containing the SQLSTATE returned by the last connection attempt string db2_conn_error ([ resource $connection ] ) db2_conn_error() returns an SQLSTATE value representing the reason the last attempt to connect to a database failed. As db2_connect() returns FALSE in the event of a failed connection attempt, you do not pass any parameters to db2_conn_error() to retrieve the SQLSTATE

(PECL ibm_db2 >= 1.0.0) Returns the last connection error message and SQLCODE value string db2_conn_errormsg ([ resource $connection ] ) db2_conn_errormsg() returns an error message and SQLCODE value representing the reason the last database connection attempt failed. As db2_connect() returns FALSE in the event of a failed connection attempt, do not pass any parameters to db2_conn_errormsg() to retrieve the associated e

(PECL ibm_db2 >= 1.0.0) Commits a transaction bool db2_commit ( resource $connection ) Commits an in-progress transaction on the specified connection resource and begins a new transaction. PHP applications normally default to AUTOCOMMIT mode, so db2_commit() is not necessary unless AUTOCOMMIT has been turned off for the connection resource. Parameters: connection A v