©
This document uses PHP Chinese website manual Release
(PECL ibm_db2 >= 1.1.1)
db2_client_info — Returns an object with properties that describe the DB2 database client
$connection
)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:
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:
|
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)