db2_client_info

(PECL ibm_db2 >= 1.1.1)

db2_client_infoReturns an object with properties that describe the DB2 database client

说明

db2_client_info ( resource $connection ) : object

This function returns an object with read-only properties that return information about the DB2 database client. The following table lists the DB2 client properties:

DB2 client properties
Property name Return type Description
APPL_CODEPAGE int The application code page.
CONN_CODEPAGE int The code page for the current connection.
DATA_SOURCE_NAME string The data source name (DSN) used to create the current connection to the database.
DRIVER_NAME string The name of the library that implements the DB2 Call Level Interface (CLI) specification.
DRIVER_ODBC_VER string The version of ODBC that the DB2 client supports. This returns a string "MM.mm" where MM is the major version and mm is the minor version. The DB2 client always returns "03.51".
DRIVER_VER string The version of the client, in the form of a string "MM.mm.uuuu" where MM is the major version, mm is the minor version, and uuuu is the update. For example, "08.02.0001" represents major version 8, minor version 2, update 1.
ODBC_SQL_CONFORMANCE string

The level of ODBC SQL grammar supported by the client:

MINIMUM

Supports the minimum ODBC SQL grammar.

CORE

Supports the core ODBC SQL grammar.

EXTENDED

Supports extended ODBC SQL grammar.

ODBC_VER string The version of ODBC that the ODBC driver manager supports. This returns a string "MM.mm.rrrr" where MM is the major version, mm is the minor version, and rrrr is the release. The DB2 client always returns "03.01.0000".

参数

connection

Specifies an active DB2 client connection.

返回值

Returns an object on a successful call. Returns FALSE on failure.

范例

Example #1 A db2_client_info() example

To retrieve information about the client, you must pass a valid database connection resource to db2_client_info().

<?php
$conn 
db2_connect'SAMPLE''db2inst1''ibmdb2' );
$client db2_client_info$conn );

if (
$client) {
    echo 
"DRIVER_NAME: ";           var_dump$client->DRIVER_NAME );
    echo 
"DRIVER_VER: ";            var_dump$client->DRIVER_VER );
    echo 
"DATA_SOURCE_NAME: ";      var_dump$client->DATA_SOURCE_NAME );
    echo 
"DRIVER_ODBC_VER: ";       var_dump$client->DRIVER_ODBC_VER );
    echo 
"ODBC_VER: ";              var_dump$client->ODBC_VER );
    echo 
"ODBC_SQL_CONFORMANCE: ";  var_dump$client->ODBC_SQL_CONFORMANCE );
    echo 
"APPL_CODEPAGE: ";         var_dump$client->APPL_CODEPAGE );
    echo 
"CONN_CODEPAGE: ";         var_dump$client->CONN_CODEPAGE );
}
else {
    echo 
"Error retrieving client information.
     Perhaps your database connection was invalid."
;
}
db2_close($conn);

?>

以上例程会输出:

DRIVER_NAME: string(8) "libdb2.a"
DRIVER_VER: string(10) "08.02.0001"
DATA_SOURCE_NAME: string(6) "SAMPLE"
DRIVER_ODBC_VER: string(5) "03.51"
ODBC_VER: string(10) "03.01.0000"
ODBC_SQL_CONFORMANCE: string(8) "EXTENDED"
APPL_CODEPAGE: int(819)
CONN_CODEPAGE: int(819)

参见

  • db2_server_info() - Returns an object with properties that describe the DB2 database server

相关文章
php ibm db2 函数 returns or sets the autocommit state for a database connectionphp ibm db2 函数 returns an object with properties that describe the db2 database clientphp ibm db2 函数 returns a connection to a databasephp ibm db2 函数 returns the cursor type used by a statement resourcephp ibm db2 函数 returns an array indexed by column position representing a row in a result setphp ibm db2 函数 returns an array indexed by column name representing a row in a result setphp ibm db2 函数 returns an object with properties representing columns in the fetched rowphp ibm db2 函数 returns the width of the current value of the indicated column in a result setphp ibm db2 函数 returns a result set listing the foreign keys for a tablephp ibm db2 函数 returns the auto generated id of the last insert query that successfully executed on this connectionphp ibm db2 函数 returns a persistent connection to a databasephp ibm db2 函数 returns a result set listing the stored procedures registered in a databasephp ibm db2 函数 returns a single column from a row in the result setphp ibm db2 函数 returns an object with properties that describe the db2 database serverphp ibm db2 函数 returns a result set listing the unique row identifier columns for a tablephp ibm db2 函数 returns a result set listing the index and statistics for a tablephp ibm db2 函数 returns a string containing the sqlstate returned by an sql statementphp ibm db2 函数 returns a result set listing the tables and associated privileges in a databasephp ibm db2 函数 returns a result set listing the tables and associated metadata in a databasephp sqlite 函数 opens an sqlite database and returns an sqlitedatabase object
关注编程学问公众号