db2_client_info

Returns an object with properties that describe the DB2 database client (PECL ibm_db2:1.1.1-1.6.2)
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:

Table 125. 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".

Parameters

connection: Specifies an active DB2 client connection.

Return Values

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

Examples

Example 916. A db2_client_info() example

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

copy to clipboard

<?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);

?>

The above example will output: