I'm getting the following error when I try to FTP this file. This job currently runs via ReportCaster with no problems to an Egate server. This server is being upgraded to Ensemble, so I am using a test program to see if I can get this to work by updating the server name to an IP address and also the sign-on/password. This is a modified version of the production file using the car file. The new server has Secure FTP (FTP is not loaded) so I am being asked if we can send this as Secure FTP through WebFOCUS. Can this be done? Most of the other topics around Secure FTP seem to relate to UNIX and not Windows. Would it be as simple as modifying the DOS command and would this really be secure? We have the option of FTPing this file to our FTP server and then Ensemble picking the file up from there, but wanted to try this first if it could work so as to eliminate extra work on both sides.

0 NUMBER OF RECORDS IN TABLE= 10 LINES= 10
ftp> open 01.27.98.25
> ftp: connect :Connection refused
ftp> signon
Invalid command.
ftp> p@ssword
Invalid command.
ftp> put \\servdon\d$\IBI\APPS\HELDFILES\RYANCART.TXT VH_RYANCART_20160908.TXT
Not connected.
ftp> close
Not connected.
ftp> bye

Code is below:

SET EMPTYREPORT=ON
-SET &THISDAY = &YYMD;

-SET &TXTFILE = 'VH_RYANCART_'||&THISDAY ||'.TXT';
-SET &SAVEFILE = 'RYANCART.TXT';
-SET &ASFILE = &SAVEFILE |' '| &TXTFILE;
-SET &FTPFILE = 'RYANCART.FTP';
-SET &FTPPATH = '\\servdon\d$\IBI\APPS\HELDFILES\';
-SET &PUTSTMT = 'put '|&FTPPATH||&ASFILE;
-SET &FDFTPCMD = 'DISK '|&FTPPATH||&FTPFILE;
-SET &EXFTP = '-s:'||&FTPPATH||&FTPFILE;


-******Store the resultant file as a text file in the HELDFILES shared folder
-SET &RPTFILE = RYANCART.TXT;
-SET &LOCATION = '\\servdon\d$\IBI\APPS\HELDFILES\';
FILEDEF RYANWCAR DISK &LOCATION&RPTFILE
-******

JOIN CLEAR *
-*
TABLE FILE CAR
PRINT CAR BY COUNTRY
ON TABLE HOLD AS RYANWCAR
END

FILEDEF FTPCMDS &FDFTPCMD
-*
-RUN
-WRITE FTPCMDS open 01.27.98.25
-WRITE FTPCMDS signon
-WRITE FTPCMDS p@ssword
-WRITE FTPCMDS &PUTSTMT
-WRITE FTPCMDS close
-WRITE FTPCMDS bye
-RUN
-**************************************************************************************************
-**** EXECUTE FTP
DOS ftp &EXFTP
-RUN


Thanks.

This message has been edited. Last edited by: <Emily McAllister>,

You can do command line SFTP, but you are going to have to find a SFTP client that allows it. You are still going to have to set your keys up etc. I did this for a client 5 years ago, but I cannot recall what windows SFTP client I was using. For that customer, the server was set up for key exchange plus credentials. If you only need key exchange, then any SSH client will do.

Usually when I need UNIX tools like sftp on DOS systems, I grab MSYS + MingW. See: http://www.mingw.org/wiki/msys

I noticed they split off the previously pre-packaged utilities (I think ssh/sftp were among them) and now require you to separately download those with mingw-get. I hope that it can handle MS corporate network proxies that use NTLM/Kerberos for authentication...

Thanks for the suggestions. We ended up sending the file to our FTP server. This ended up being the quickest and easiest solution.