PHP db2_client_info function

Like this blog? Consider exploring one of our sponsored banner ads...

db2_client_info

(no version information, might be only in CVS)

db2_client_info — Returns an object with properties that describe the DB2 database clientDescriptionobject 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 1. DB2 client properties

Property nameReturn typeDescriptionAPPL_CODEPAGEintThe application code page.CONN_CODEPAGEintThe code page for the current connection.DATA_SOURCE_NAMEstringThe data source name (DSN) used to create the current connection
to the database.DRIVER_NAMEstringThe name of the library that implements the DB2 Call
Level Interface (CLI) specification.DRIVER_ODBC_VERstringThe 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_VERstringThe 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_CONFORMANCEstringThe 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_VERstringThe 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 1. A db2_client_info() example

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

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

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)

See Also

db2_server_info()


About this entry

You’re currently reading “PHP db2_client_info function,” an entry on BRADINO

Published:
2.26.07 / 1am
Category:
PHP Functions
Tags: