db2_client_info

(PECL ibm_db2 >= 1.1.1)

db2_client_info — Returns an object with properties that describe the DB2 database client

说明

object db2_client_info ( resource $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:

**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