Network CSV files to mainframe

[SPhill]

I'm using SAS 8.2 on MVS mainframe using JCL and I'd like to read in some CSV files directly from a network we have here in work. I could copy the files into our mainframe but this would be a bit messy and time consuming and I'm wondering if there is a way of directing my DSN in the JCL directly to these files on our network, is that possible? Are there any other alternatives?

Thanks

SP

 

[jymm]

when I was working on a mainframe there was an FTP program that we used for this exact use --- so that I could run it against SAS ---

 

[ChrisW75]

Hi,
I'm not sure if it's possible as the Mainframe generally can't see the network. The best people to ask would be your network/mainframe support people to see if there is some common storage area accessible from both sides. Alternatively do as jymm suggested and incorporate and ftp process into your JCL so that it runs when the job runs.

 

[SPhill]

Thanks for the replies, I use an FTP programme called Reflection FTP for Windows NT Version 7.00, it's pretty handy and I use it a lot, mainly for click and drag but I've also set up some scripts for it to run in the background which is what I'll do for this. I didn't think mainframe wouold be able to directly look at network files.

Just out of curiosity is there a way of getting a script to run via your JCL using this FTP? It looks like Reflections FTP is created by WRQ Inc and it's got all the IP address's etc in 'about reflections FTP', including a picture of 'Mount Stuart' which is 'located in the central Cascades of Washington state' and was named by 'Capt. George B. McClellan on September 30, 1853'!!!

thanks

SP

 

[ChrisW75]

No idea, however, you should look into Connectirect. It's a program that runs on both unix and the Mainframe, you can set it up to run scripts on the mainframe from unix or vice versa. The product is made by Stirling Commerce, apparently it's pretty handy, though I've not used it myself, this could be the answer you're after. I've not really used the mainframe in about 5-6 years.
It's quite possible that you've already got the software there as it seems pretty pervasive.