How to download multiple files from FTP server to mainframe?

raj12vel · Posted: Wed Jul 15, 2009 11:21 pm

Hi All,

I have 22 files in SAS server. I want to download all the 22 files from FTP server to mainframe as a single file.

I have tried APPE and MGET comand. but not getting the actual result.

can any one help me how to append the files in mainframe from server?

superk · Posted: Wed Jul 15, 2009 11:29 pm

What would I do in this case?

Run the FTP the first time and do a member list (LS) command and pull that information back into a dataset. Read that datatset, and dynamically build 22 seperate GET commands, all pointing to the one single DD for my local dataset. That DD would, of course, be specified in the allocation with DISP=MOD.

Run the FTP a second time, using the 22 dynamically built GET commands.

superk · Posted: Wed Jul 15, 2009 11:31 pm

Do these filenames conform to normal MVS dataset naming conventions? If so, I have other ideas as well.

raj12vel · Posted: Wed Jul 15, 2009 11:35 pm

superk · Posted: Wed Jul 15, 2009 11:40 pm

22 GET's or 22 APPEND's. I don't see any other options that don't involve using something like PKZIP. Maybe someone else does?

raj12vel · Posted: Wed Jul 15, 2009 11:46 pm

Do u know, how to give append command for this issue?

Robert Sample · Posted: Thu Jul 16, 2009 12:02 am

The APPEND FTP command is used like a PUT command -- not a GET command. AFAIK, there is no way to accomplish the requested task except the procedure Kevin outlined -- get the names, generate a sequence of GET commands, then run them through another FTP session. FTP is oriented around transfer of one (or more) files -- it wasn't designed to transfer multiple files to one file.

raj12vel · Posted: Thu Jul 16, 2009 12:11 am

is that possible to use MGET command?

If so, just give me the syntax?

Robert Sample · Posted: Thu Jul 16, 2009 12:20 am

You can use the MGET command, but be aware that you will not get one file on the receiving end -- you will get one file per sending file, or 22 files per the original post.

Depending upon the default settings, you may need to use PROMPT (which toggles the prompting to download each individual file). The FTP command is MGET * to retrieve all files from the current working directory on the remote server. MGET file1 file2 file3 would retrieve from the remote server file1, then file2, then file3 -- storing them as three separate files on the local machine.

raj12vel · Posted: Thu Jul 16, 2009 12:24 am

Thanks for your quick reply.

Can you please give me the code with syntax for MGET?

superk · Posted: Thu Jul 16, 2009 12:34 am

Robert, you're right. My bad about the APPEND command.

Unfortunately, from what the OP has shown, unless those filenames are changed to conform to normal MVS dataset naming conventions, I don't see using the MGET command.

raj12vel · Posted: Thu Jul 16, 2009 12:41 am

Yes, you are right.

I have used the MGET *.txt local file name.

but got the error as ' No such file or directory.'

EZA1685W Invalid local file identifier

can you tell me what is MVS naming conventions?

superk · Posted: Thu Jul 16, 2009 12:55 am

This is from your example:

'X1GPTLH.RCF.CLOSE08.CLI.ACCTS.JUL15'

Multiple nodes, each seperated by a period. A node may be 1-8 alphanumeric characters, but must start with a national character (A-Z, #, or $). No blanks or underscores or other characters.

raj12vel · Posted: Thu Jul 16, 2009 12:57 am

Thats what i have given as the file name rt

then why is not accepting?

superk · Posted: Thu Jul 16, 2009 1:05 am

Robert Sample · Posted: Thu Jul 16, 2009 1:17 am

You can't provide a local file name with the MGET command -- all operands on the MGET are remote server file names.

Should you need more assistance, could you post your FTP commands as you have them (we don't need the IP address, user id, or password) in the output of the FTP job so we can see exactly what you've got?

superk · Posted: Thu Jul 16, 2009 1:26 am

My job, as I originally mentioned, would look something like this:

raj12vel · Posted: Thu Jul 16, 2009 1:46 am

Can you please be more specific on the aforementioned code?

1. do i have to give the ip address in the field?

raj12vel · Posted: Thu Jul 16, 2009 1:55 am

I got it.

It works fine.

thanks alot for your timed help.

please let me know if we have alternatives for this.

I would like to thank you al