db2_client_info

(PECL ibm_db2 >= 1.1.1)

db2_client_infoReturns an object with properties that describe the DB2 database client

Description

db2_client_info(resource $connection): object

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

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

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

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() - Returns an object with properties that describe the DB2 database server

Here you can write a comment


Please enter at least 10 characters.
Loading... Please wait.
* Pflichtangabe
There are no comments available yet.

PHP cURL Tutorial: Using cURL to Make HTTP Requests

cURL is a powerful PHP extension that allows you to communicate with different servers using various protocols, including HTTP, HTTPS, FTP, and more. ...

TheMax

Autor : TheMax
Category: PHP-Tutorials

Midjourney Tutorial - Instructions for beginners

There is an informative video about Midjourney, the tool for creating digital images using artificial intelligence, entitled "Midjourney tutorial in German - instructions for beginners" ...

Mike94

Autor : Mike94
Category: KI Tutorials

Basics of views in MySQL

Views in a MySQL database offer the option of creating a virtual table based on the result of an SQL query. This virtual table can be queried like a normal table without changing the underlying data. ...

admin

Autor : admin
Category: mySQL-Tutorials

Publish a tutorial

Share your knowledge with other developers worldwide

Share your knowledge with other developers worldwide

You are a professional in your field and want to share your knowledge, then sign up now and share it with our PHP community

learn more

Publish a tutorial