djolecodes / db2-laravel-driver
DB2 for IBM iSeries drop-in Laravel driver
Requires
- php: ^8.1
- illuminate/contracts: ^9|^10|^11|^12.0
- illuminate/database: ^9.4|^10|^11|^12.0
- illuminate/support: ^9|^10|^11|^12.0
- spatie/laravel-package-tools: ^1.13.0
Requires (Dev)
- nunomaduro/collision: ^6.0
- orchestra/testbench: ^7.0|^10.0
- pestphp/pest: ^1.21|^3.7
- pestphp/pest-plugin-laravel: ^1.1|^3.1
- phpunit/phpunit: ^9.5|^11.5.3
This package is auto-updated.
Last update: 2025-06-17 08:36:30 UTC
README
This package allows you to use Laravel's query builder and eloquent with DB2 for IBM iSeries by extending the Illuminate Database component of the Laravel framework. Originally forked from BWICompanies.
Modification done by me is that we can't use the IBM DB2 driver but only odbc, by specifying the use_ibm_driver=true connection string will be created for the IBM DB2 driver instead for the ODBC like previous authors intended. I've done this only because I cant use the cooperl22/laravel-db2. And I want to use the regular IBM DB2 driver with laravel 10. Since this package works with Laravel 10 I forked the repo and made small modification in the connection string.
Requirements
- IBM dsdriver installed {IBM DB2 ODBC DRIVER}
- IBM PDO INSTALLED
Installation
Install the package via composer:
composer require djolecodes/db2-laravel-driver
Add a new connection in database.php:
Note: You can specify the connection name, but the driver must be 'db2'
'myDB2Connection' => [ 'driver' => 'db2', 'driverName' => '{IBM DB2 ODBC DRIVER}', 'host' => env('DB_HOST'), 'username' => env('DB_USERNAME'), 'password' => env('DB_PASSWORD'), 'database' => env('DB_DATABASE'), 'prefix' => '', 'use_ibm_driver'=> true, 'schema' => env('DB_SCHEMA'), 'port' => env('DB_PORT', 50000), 'date_format' => 'Y-m-d H:i:s', // or 'Y-m-d H:i:s.u' / 'Y-m-d-H.i.s.u' 'offset_compatibility_mode' => true, 'odbc_keywords' => [ 'SIGNON' => 3, 'SSL' => 0, 'CommitMode' => 0, 'ConnectionType' => 0, 'DefaultLibraries' => '', 'Naming' => 1, 'UNICODESQL' => 0, 'DateFormat' => 5, 'DateSeperator' => 0, 'Decimal' => 0, 'TimeFormat' => 0, 'TimeSeparator' => 0, 'TimestampFormat' => 0, 'ConvertDateTimeToChar' => 0, 'BLOCKFETCH' => 1, 'BlockSizeKB' => 32, 'AllowDataCompression' => 1, 'CONCURRENCY' => 0, 'LAZYCLOSE' => 0, 'MaxFieldLength' => 15360, 'PREFETCH' => 0, 'QUERYTIMEOUT' => 1, 'DefaultPkgLibrary' => 'QGPL', 'DefaultPackage' => 'A /DEFAULT(IBM),2,0,1,0', 'ExtendedDynamic' => 1, 'QAQQINILibrary' => '', 'SQDIAGCODE' => '', 'LANGUAGEID' => 'ENU', 'SORTTABLE' => '', 'SortSequence' => 0, 'SORTWEIGHT' => 0, 'AllowUnsupportedChar' => 0, 'CCSID' => 1208, 'GRAPHIC' => 0, 'ForceTranslation' => 0, 'ALLOWPROCCALLS' => 0, 'DB2SQLSTATES' => 0, 'DEBUG' => 0, 'TRUEAUTOCOMMIT' => 0, 'CATALOGOPTIONS' => 3, 'LibraryView' => 0, 'ODBCRemarks' => 0, 'SEARCHPATTERN' => 1, 'TranslationDLL' => '', 'TranslationOption' => 0, 'MAXTRACESIZE' => 0, 'MultipleTraceFiles' => 1, 'TRACE' => 0, 'TRACEFILENAME' => '', 'ExtendedColInfo' => 0, ], 'options' => [ PDO::ATTR_CASE => PDO::CASE_LOWER, PDO::ATTR_EMULATE_PREPARES => false, PDO::ATTR_PERSISTENT => false, ] ],
Note: Be sure to define the appropriate keys in
.env.
Other Resources
License
The MIT License (MIT). Please see License File for more information.