Run PHP script in AS/400 batch

62385 pts.
Tags:
AS/400
MySQL
PHP
We have an application on our AS/400 where we are passing changes to data down to a MYSQL DB on a server. Using a purchased product we have issues when passing large amounts of data, Were get JAVA heap dumps. So I am replacing this with a PHP process. The RPG code writes SQL statements to a file (PHPIN), then we have a PHP script that gets called and executes a script that reads through the file running thousands of SQL statements. This works fine, except it take human intervention to start the script. I need to be able to submit a batch job on the AS/400 that will run the script. Anyone have any ideas on how to do this?


Software/Hardware used:
V7R1, MYSQL 5.5
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

No need for anyone to answer, I found an excellent answer on the web.

http://www.alanseiden.com/presentation%20slides/PHP-for-batch-tasks-on-IBM%20i.pdf

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: