README

Doctrine DBAL PDO implementation against DB2 on your IBM i platform.

Usage

It can be used :

• On your IBM i
• On your local machine
• Within a Docker container

Requirements

• PHP >= 8.1
• ext-pdo
• unixodbc
• ODBC driver for IBM i Access Client Solutions

Installation

composer require guidofaecke/doctrine-dbal-pdo-ibmi

Configuration example

<?php

use Doctrine\DBAL\IBMIDB2PDO\Driver\Driver as IBMIDB2PDODriver;

return [
    'doctrine' => [
        'connection'  => [
            'orm_default' => [
                'driver_class' => IBMIDB2PDODriver::class,
                'params'       => [
                    'host'     => '10.10.10.10',
                    'dbname'   => 'S1234abc',
                    'user'     => 'db_user',
                    'password' => 'password',
                    'charset'  => 'utf8',
                    'naming'   => '1',
                ],
            ],
        ],
    ],
];

Caution

Even if doctrine migration is working, be warned that system default libraries/schemas are included. Be aware that migration files will include a fair amount of DROP statements from these schemas.