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

A more secure and simpler to automate (with key based authentication
instead of passwords) is using scp instead of ftp.

"MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx> wrote on 03/09/2016
08:57:20 PM:

From: "midrange" <franz9000@xxxxxxxxx>
To: "'Midrange Systems Technical Discussion'" <midrange-l@xxxxxxxxxxxx>
Date: 03/09/2016 08:57 PM
Subject: RE: Does anyone know if I can run a command on a UNIX
system to export data from a progress database?
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>

If you want the unix box to execute the extract on a schedule before the

ftp

connects, so the files are ready to pick up, you need to set up a CRON
schedule (an ancient but simple scheduler). The ftp from I executing
commands is fine but often secured to not allow.
http://www.unixgeeks.org/security/newbie/unix/cron-1.html

I'm spending more and more time on a Power unix box (websphere and DB2)
lately.. programming, with Power i still in the loop, and we use Cron

for

daily schedules.

Jim Franz

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
Darryl Freinkel
Sent: Wednesday, March 09, 2016 7:31 PM
To: Midrange Systems Technical Discussion
Subject: Re: Does anyone know if I can run a command on a UNIX system to
export data from a progress database?

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.
--
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.