RE: Does anyone know if I can run a command on a UNIX system to export data from a progress database?

Not sure if you're open to commercial options, but our Automate software can:

-Connect to the box
-Run shell scripts and process results. In your case that would be running whatever Progress utilities are there.
-Turn around and send or receive files via FTP/SFTP/FTPS
-Then kick off the IBM i processes to import that data and monitor the whole thing end to end.

Think of it as CL programming for Windows.

If you're interested in checking it out:
http://www.helpsystems.com/automate

Try it out for yourself.

Regards,
 
Richard Schoen | Director of Document Management Technologies, HelpSystems
T: + 1 952-486-6802
RJS Software Systems | A Division of HelpSystems
richard.schoen@xxxxxxxxxxxxxxx
www.rjssoftware.com
 

-----Original Message-----

On Wed, Mar 9, 2016 at 10:34 AM, Darryl Freinkel <dhfreinkel@xxxxxxxxx>
wrote:

I can build progress exports to a .csv or .txt file on the UNIX system.

The system is running an old version of progress.

I want to dump the files on a regular basis and import them into
tables on the IBM I. I have setup FTP to do this and it works well but
I have to run the exports manually.

What I would like to do, is from the FTP script, run the progress
results export features to build the export files and then pull the
files onto the IBM I. Has anyone done or does any have suggestions on how to do this?

TIA.

Darryl Freinkel
iPad
--