05-19-2016 02:05 AM
I have the below requirement in our project. Please do the needful.
Do FTP connection and retrieve the files from different FTP server.
FTP Credentials (FTP User name, Password, FTP server details) in the mainframe PS file.
Connect with FTP server using the credetials in the input file and Retrieve the files from server using 'FILENAME' statement.
If there is any FTP error, Retry the FTP connection three times or till successful
The error should be written into the error output file and the program should continue for the next server.
Success output file with retrieved data
Error output file with FTP connection error.
Whenever there is FTP connection error, the program throws error with MAXCC = 8.
Option 1: Overwriting the system return code to JCL.
Option 2: Before foing FTP connection for retrieving, i want to check whether the server is UP or down to avoid the error.
Appreciate your help.
Thanks in advance,
05-19-2016 02:21 AM
To check if a server is up, one usually uses ping. So you will have to look for the MF equivalent of this UNIX-typical utility.
data _null_; x = system("ping -c1 server_that_is_up"); put x=; x = system("ping -c1 server_that_is_not_up"); put x=; run;
would produce this in the log:
16 data _null_; 17 x = system("ping -c1 server_that_is_up"); 18 put x=; 19 x = system("ping -c1 server_that_is_not_up"); 20 put x=; 21 run; x=0 x=1 NOTE: DATA statement used (Total process time): real time 0.02 seconds cpu time 0.01 seconds
on a UNIX type SAS server.
The current state of the SAS session is kept in the automatic macro variable SYSCC. You can check for this state before and after your data step that uses the FTP connection; if necessary, you can set SYSCC back to 0 with a simple
05-19-2016 03:03 AM
I can't see anything in the requirements that would make a SAS session for this beneficial. This could be (better?) handled by OS/ftp commands directly.