Natif DB2 Connector for WINDEV and WEBDEV

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Help

Native Connectors/Native Accesses

Native DB2 Connector

Natif DB2 Connector for WINDEV and WEBDEV

Overview

Required configuration

Use

See also

Natif DB2 Connector for WINDEV and WEBDEV

Available only with this kind of connection

Overview

WINDEV and WEBDEV propose an optional Native Connector to DB2 (also called "Native Access to DB2"). This Native Connector allows you to access a DB2 database from a WLanguage program without using any external driver.

Caution: This version of Native DB2 Connector operates with WINDEV and WEBDEV only.

Required configuration

Conditions for using Native DB2 Connector

DB2 version 7.1 or later (Native Connector tested by us with versions 8.2 and 10).
The DB2 client on each computer accessing DB2.
DB2CLI.DLL must be accessible:
- from the development computer,
- from the deployment computer.

The necessary files

The following files are required to use Native DB2 Connector:

in 32 bits:
- DB2CLI.DLL. This DLL is installed by the 32-bit client layer of DB2. See the license agreement of DB2 for more details about the distribution conditions of this DLL.
- wdxxxdb2.dll. Required for Native Connector to a DB2 database in 32-bit mode. This file is supplied with Native Connector for DB2.

Versions 19 and later

in 64 bits:
- DB2CLIO.DLL. This DLL is installed by the 64-bit client layer of DB2. See the license agreement of DB2 for more details about the distribution conditions of this DLL.
- wdxxxdb2_64.dll. Required for Native Connector to a DB2 database in 64-bit mode. This file is supplied with Native Connector for DB2.

New in version 19

in 64 bits:
- DB2CLIO.DLL. This DLL is installed by the 64-bit client layer of DB2. See the license agreement of DB2 for more details about the distribution conditions of this DLL.
- wdxxxdb2_64.dll. Required for Native Connector to a DB2 database in 64-bit mode. This file is supplied with Native Connector for DB2.

in 64 bits:
- DB2CLIO.DLL. This DLL is installed by the 64-bit client layer of DB2. See the license agreement of DB2 for more details about the distribution conditions of this DLL.
- wdxxxdb2_64.dll. Required for Native Connector to a DB2 database in 64-bit mode. This file is supplied with Native Connector for DB2.

Use

To use Native DB2 Connector in your WINDEV applications or in your WEBDEV sites

To use DB2 in native mode, you must program:

With the "SQL" functions of WLanguage (see Programming with SQL functions).
With the "HFSQL" functions of WLanguage (see Programming with HFSQL functions).

Remark: Don't forget to read the limitations regarding the use of Native DB2 Connector.