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

[Darryl Freinkel <dhfreinkel@xxxxxxxxx>]

Yes, for now FTP would be the choice.

Darryl Freinkel
iPad

> On Mar 9, 2016, at 11:41 AM, Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx> wrote:
>
> Darryl
>
> I assume you are using the IBM i as the FTP client - right? If so, see if you can use
>
>     quote rcmd [the unix command you want to run]
>
> against the FTP server on the Unix box.
>
> You could try
>
>     quote ?
>
> in your FTP session to see what subcommands are available on the Unix box.
>
> You might also be able to have a process on the Unix box waiting for a file to arrive - then do a PUT of that marker file when you want something to happen - I think I did something like that 20 years ago, long deep memory hole there!
>
> HTH
> Vern
>
> > On 3/9/2016 11:34 AM, Darryl Freinkel 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.