Link to home
Start Free TrialLog in
Avatar of miraclemaxnd
miraclemaxnd

asked on

How to launch .exe pgm from within FTP to MS SQL server to proces uploaded files

I have a client that we are transferring order files to a MS SQL Server from IBM iSeries using FTP
Once the file transfers have completed, the client wants us to run a pgm that will process the uploaded files.
I have been unable to make the QUOTE cmd in FTP run the remote cmd. I have been reluctant to look at using
RUNRMTCMD since it opens up the Host system to incoming remote cmds.

The clients' vendor has suggested running an HTTP cmd but not sure how to launch that via FTP or
from within my CL pgm.

Any suggestions would be greatly appreciated.
Avatar of Aaron Tomosky
Aaron Tomosky
Flag of United States of America image

You could make a batch file that checks the FTP folder and runs the command if the file is there. Schedule that to run every few min
Avatar of miraclemaxnd
miraclemaxnd

ASKER

They are using that method currently and they can't set the time between checks to be less than 1 miinute so that won't work which is why I am looking for a way to launch the .bat or .exe to run after I have uploaded my files.
Maybe we could improve the batch file they use to resolve this 1 minute limmitation.
ASKER CERTIFIED SOLUTION
Avatar of Gary Patterson, CISSP
Gary Patterson, CISSP
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial