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

Anything to avoid a manual process ..

Run the FTP script as a cron job on Unix but conditional on the progress
files being available for export. Once the progress files have been sent to
a target folder on the IBM i, send a trigger file to indicate completion
and close down.

On the IBM i run a scheduled job (ROBOT?) to poll the target folder for
arrival of the trigger file. Once arrived, process the progress .csv files
as required.

Cheers

Keith

On 9 March 2016 at 18:05, Nathan Andelin <nandelin@xxxxxxxxx> wrote:

Running Progress exports manually at regular intervals sounds like a pain.
How long would you have to keep that going?

What do you think of the suggestion to use a JDBC driver to pull data from
Progress? You might use that from an IBM i batch process.



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
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.