FTP in Mainframe SAS

Reply
Learner
Posts: 1

FTP in Mainframe SAS

Hi,

 

I have the below requirement in our project. Please do the needful.

Requirement:

Do FTP connection and retrieve the files from different FTP server.

 

Input:

FTP Credentials (FTP User name, Password, FTP server details) in the mainframe PS file.

 

Process:

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.

 

Output:

Success output file with retrieved data

Error output file with FTP connection error.

 

Issue:

Whenever there is FTP connection error, the program throws error with MAXCC = 8.

 

Expected solution:

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,

Saradhadevi. I

Super User
Posts: 6,936

Re: FTP in Mainframe SAS

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

%let syscc=0;
---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Super User
Posts: 5,256

Re: FTP in Mainframe SAS

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.

Data never sleeps
Ask a Question
Discussion stats
  • 2 replies
  • 265 views
  • 2 likes
  • 3 in conversation