Re: Linux to AS/400 from RPG

[Joel Cochran <jrc@xxxxxxxxxx>]

On Fri, 2004-07-09 at 14:04, Jeffrey Lee wrote:
> I want to take a file containing orders from a linux mysql database and move
> it over to an AS/400. How can I do this from an RPG program?
> 
> The users will enter orders into a website (which puts the data into a
> database) then when they press accecpt it will tell someone at this company
> that there is an order waiting for verification. That person will then check
> the order, put prices and send back a copy with the prices. If the person
> accepts the prices then he will click a button and it is the sales rep's job
> to take this order and put it into the as/400. I can do the website portion
> very easily. The only problem I have is figuring out the best way to put the
> data on the as/400, in the correct places.
> 
> Any input would be great
> 
> Jeffrey Lee

Jeffrey,

I only have a quick moment, but my first thought would be to do a
MySQLDump to a text file, FTP the file to the IFS, and have an RPG
program read the file in and execute each statement.  The dump is a
native utility for MySQL and contains all the statements you need to
recreate the tables and insert the records.

This will, of course, send the database whole cloth, so it may not help,
but maybe it will spur an idea... also, watch out for things we take for
granted in MySQL like 'auto-increment'... that won't work on the 400.

HTH,

Joel
http://www.rpgnext.com