(PHP 4, PHP <=5.2.0) Close Informix connection bool ifx_close ([ resource $link_identifier ] ) ifx_close() closes the link to an Informix database that's associated with the specified link identifier. Note that this isn't usually necessary, as non-persistent open links are automatically closed at the end of the script's execution. ifx_close() will not close persistent links generated by ifx_pconnect().

(PHP 4, PHP <=5.2.0) Set the default byte mode bool ifx_byteasvarchar ( int $mode ) Sets the default byte mode for all select-queries. Parameters: mode Mode "0" will return a blob id, and mode "1" will return a varchar with text content. Returns: Returns TRUE on success or FALSE on failure.

(PHP 4, PHP <=5.2.0) Set the default blob mode for all select queries bool ifx_blobinfile_mode ( int $mode ) Set the default blob mode for all select queries. Parameters: mode Mode "0" means save Byte-Blobs in memory, and mode "1" means save Byte-Blobs in a file. Returns: Returns TRUE on success or FALSE on failure.

(PHP 4, PHP <=5.2.0) Get number of rows affected by a query int ifx_affected_rows ( resource $result_id ) Returns the number of rows affected by a query associated with result_id. For inserts, updates and deletes the number is the real number (sqlerrd[2]) of affected rows. For selects it is an estimate (sqlerrd[0]). Don't rely on it. The database server can never return the actual number of rows that will be returned by

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

(PECL ibm_db2 >= 1.0.0) Returns a result set listing the tables and associated privileges in a database resource db2_table_privileges ( resource $connection [, string $qualifier [, string $schema [, string $table_name ]]] ) Returns a result set listing the tables and associated privileges in a database. Parameters: connection A valid connection to an IBM DB2, Cloudsc

(PECL ibm_db2 >= 1.0.0) Returns a string containing the last SQL statement error message string db2_stmt_errormsg ([ resource $stmt ] ) Returns a string containing the last SQL statement error message. If you do not pass a statement resource as an argument to db2_stmt_errormsg(), the driver returns the error message associated with the last attempt to return a statement resource, for example, from db2_prepare() or db2

(PECL ibm_db2 >= 1.0.0) Returns a string containing the SQLSTATE returned by an SQL statement string db2_stmt_error ([ resource $stmt ] ) Returns a string containing the SQLSTATE value returned by an SQL statement. If you do not pass a statement resource as an argument to db2_stmt_error(), the driver returns the SQLSTATE value associated with the last attempt to return a statement resource, for example, from db2_prepa

(PECL ibm_db2 >= 1.0.0) Returns a result set listing the index and statistics for a table resource db2_statistics ( resource $connection, string $qualifier, string $schema, string $table-name, bool $unique ) Returns a result set listing the index and statistics for a table. Parameters: connection A valid connection to an IBM DB2, Cloudscape, or Apache Derby database.

(PECL ibm_db2 >= 1.0.0) Returns a result set listing the unique row identifier columns for a table resource db2_special_columns ( resource $connection, string $qualifier, string $schema, string $table_name, int $scope ) Returns a result set listing the unique row identifier columns for a table. Parameters: connection A valid connection to an IBM DB2, Cloudscape, or A