Inserting into remote DB2 database

We have data in a FreeBSD/PHP/MySQL system that we need to reformat and insert into a remote DB2 database on an AS400 mainframe whenever we make changes in the parent data set.

Can someone point me to sources that explain how we can connect to the remote system?

Thank you -- Tony

You are going to have to get some kind of db2 connection software that will allow you to connect to the db2 server on the AS/400. I believe there is a tool DB2 makes for this called DB2Connect, but it isn't cheap.

I work with an AS400 at my job as well.

The system I setup was an XML interchange between our webserver and the AS400, which runs an app made by a company called Lansa.

Lansa makes several AS400 products - the two we use allow data from the AS400 to be output as either XML or HTML. Lansa also allows the AS400 developer to quickly develop (using a WYSIWYG editor) handlers that take GET or POST information, as well as output documents.

In this manner, by exchanging XML between PHP and Lansa on the AS400, we don't actually connect to the DB2 database on the 400, but are still able to transfer crucial data back and forth.

That's interesting. The system we need to provide data to is a Lansa app. I'll contact that developer and see what his capabilities are. If he can handle the GET or POST end of things then I only need to have the data available for him

Thank you both -- Tony

Hope it works out for you.

Hope it works out for you.