Download the PHP package emkcloud/laravel-iseries-db2 without Composer
On this page you can find all versions of the php package emkcloud/laravel-iseries-db2. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Informations about the package laravel-iseries-db2
laravel-iseries-db2
Laravel Driver for DB2 on IBM iSeries (AS/400)
A modern DB2 driver for Laravel, supporting IBM i (iSeries) systems using ODBC. This package is inspired by db2-driver, but due to significant changes introduced in Laravel 12, it was necessary to rebuild the driver from scratch. Designed for Laravel and IBM i >= 7.1 release.
Features
- Laravel ^12.0|^13.0
- Compatible with IBM iSeries DB2 >= 7.1
- Compatible with
artisan db:table - Compatible with migration commands
- Using Laravel's modern Grammar
- Add Custom Laravel DB2 Methods
- Use only Query Builder, no Eloquent
Requirements
Installation
Configuration
- Define connection in database.php
- Define appropriate variables in .env
Artisan Commands
The following Laravel schema and database inspection commands have been tested and are fully supported by this driver with environment Laravel 12 and IBM iSeries 7.4:
Example Output
- Screenshot of
artisan db:table - Screenshot of
artisan db:show - Screenshot of
artisan db:show --counts - Screenshot of
artisan db:show --views
Schema Commands
Custom DB2 Methods
Retrieve a list of available IBM i libraries.
This package adds convenient methods to execute remote IBM i programs.
Migration Commands
Migration Blueprint
Laravel's Blueprint class offers a wide variety of methods for building database schemas. I focused on implementing the most essential and commonly used ones.
Migration Examples
- Example verified commands
- Example standard migration
Migration Drop & Rename
To use Drop and Rename operations, the database connection user must have the correct permissions to execute the ADDRPYLE and RMVRPYLE commands. You can grant the necessary permissions by running the following commands on the IBM i system:
If an automatic reply to the CPF32B2 message is configured directly on the central server, this warning can be ignored. If you enable automation on the central system, you must set the environment variable to false.
Other Resources
- DB2 Connection String
- Documentation PDO Attributes
- IBM i Access Driver Release Notes
- Alternative Package db2driver
- Documentation for DB2 for IBM i
License
The MIT License (MIT). Please see License File for more information.