PHPackages                             masterpis/db2as400 - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [Database & ORM](/categories/database)
4. /
5. masterpis/db2as400

ActiveLibrary[Database & ORM](/categories/database)

masterpis/db2as400
==================

Packages for Db2 As400 connection. Connection based on general connection string COM and ODBC

v1.0.7(7y ago)122MITPHPPHP ^7.1

Since Dec 13Pushed 7y ago1 watchersCompare

[ Source](https://github.com/priatmoko/Db2As400)[ Packagist](https://packagist.org/packages/masterpis/db2as400)[ RSS](/packages/masterpis-db2as400/feed)WikiDiscussions master Synced 2w ago

READMEChangelog (3)DependenciesVersions (10)Used By (0)

Db2As400
========

[](#db2as400)

Packages for managing connection to Db2 As400 using driver COM dot net and ODBC. It is built on lumen laravel. It is a collection of attributes and methods to simplify connection to DB2 As400. The main purpose of this library is standarization of code in my small organization. It will provide basic operation of database connection.

How to use it on your project.
==============================

[](#how-to-use-it-on-your-project)

Running this script on your lumen / laravel project directory `composer require masterpis/db2as400`

Database configuration on .env on laravel or lumen project

If you use ODBC Driver, you can use configuration below :

```
DB2_DRIVER=ODBC
DB2_CATALOG=
DB2_HOST=192.168.x.xx
DB2_USERNAME=user_odbc
DB2_PASSWORD=pass_odbc

```

if you use COM Driver, you can use configuration below:

```
DB2_DRIVER=COM
DB2_CATALOG=S651658X
DB2_HOST=192.168.x.xx
DB2_USERNAME=user_com
DB2_PASSWORD=pass_com

```

if you have multiple env ODBC

```
DB2_DRIVER=ODBC
DB2_CATALOG=
DB2_HOST=192.168.x.xx|192.168.xx.xxx
DB2_USERNAME=user1|user2
DB2_PASSWORD=pass1|pass2

```

if you have multiple env COM

```
DB2_DRIVER=COM
DB2_CATALOG=S651658X|S651658Y
DB2_HOST=192.168.x.xx|192.168.xx.xxx
DB2_USERNAME=user1|user2
DB2_PASSWORD=pass1|pass2

```

Open your Model, remove default eloquent and load this packages by this code `use Masterpis\Db2as400\Model;`

Change extends from default eloquent to this packages

```

```

Use your model on controller

```