DB2
DB2 is a relational database management system developed by IBM.
There are different technologies you can use to access DB2 from web applications developed with HTML5 Builder:
- The Database component, documented below. Requirements: client and PHP PDO extension.
- PHP functions, documented here. Requirements: client and PHP extension.
Contents
Installation
Client
- Download the DB2 Lite client from here.
- Extract the archive with the client.
- Copy all .dll files into your Windows\System32 directory.
PHP PDO Extension
- Download the extension's source code from here, and build it.
- Place the built php_pdo_ibm.dll file into PHP’s extensions directory.
- For HTML5 Builder’s internal server, the directory is located at php\ext, inside the installation directory.
- Enable the extension by adding the following line to PHP’s configuration file (php.ini):
extension=php_pdo_ibm.dll
- For HTML5 Builder’s internal server, apply the changes to the php.ini.template file.
PHP Extension
- Download the extension from here.
- Extract the php_ibm_db2.dll file into PHP’s extensions directory.
- For HTML5 Builder’s internal server, the directory is located at php\ext, inside the installation directory.
- Enable the PHP extension by adding the following line to PHP’s configuration file (php.ini):
extension=php_ibm_db2.dll
- For HTML5 Builder’s internal server, apply the changes to the php.ini.template file.
Configuration
Tip: You can use the Data Explorer to configure your DB2 connections the RAD way.
To use a Database component with DB2, configure it with the following property values:
- DriverName: ibm.
Then fill the rest of the mandatory properties as required.