PHP : Function Reference : IBM DB2, Cloudscape and Apache Derby Functions : db2_client

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().

<?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:

copy to clipboard

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_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 )

Example 916. A db2_client_info() example

Change Language

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 )

Example 916. A db2_client_info() example

Change Language

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 )