In message <[log in to unmask]>, Mosalie Rignon
<[log in to unmask]> writes
> Hi,
>Whaddya know, we're migrating ...
>(Well, we're getting ready.)
>
>We're uploading data files (extracted from Turbo Image on our HP3000) to a
>Windows server via FTP every so often.
>
>When - and only when - the FTP transfer has finished I would like to start a
>remote database application (on the Windows server) to begin importing the
>data.

Examine the FTP command SITE. This enables you to issue site-specific
commands which can be executed on your machine.

Windows standard FTP doesn't seem to admit to being able to issue SITE
commands, and so may not understand it when it's sent them :-(

But WS-FTP PRO, from Ipswitch, and probably other decent FTPs will
support this standard FTP command.


As the initiating FTP job is under your control, add a SITE command to
launch the script to import the data, at a point where you know the FTP
transfer has completed successfully.

Understandably (!), you may have to place the script somewhere where the
receiving FTP server can both see it and agree that this is something
the sending FTP job has permission to run...

I used to use this approach to FTP data from our HP3000 to an AS/400,
and to launch a job on the AS/400 to process it, but I no longer have
the specifics to hand... and nor do I quite know what setup on theAS400
was needed in order to allow this safely.

But I do know that the HP3000 FTP (Arpa) has the command. And the server
will accept SITE STREAM jobname, which is the closest MPE/iX equivalent
of what you want to do on the Windows side.

So it's a thing to look at... read up on the SITE command in your
Windows FTP product documentation and/or help. Ad if you only have the
standard bundled Microsoft FTP, look for a better commercial one to use,
perhaps...



--
Roy Brown        'Have nothing in your houses that you do not know to be
Kelmscott Ltd     useful, or believe to be beautiful'  William Morris

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *