Mainframe Help Forums

Hi,

I have a dataset which has policy information..( All the records of Variable length)
I need to write a jcl which takes this as input and when i submit this jcl,the record info should get updated in a spread sheet
(Microsoft Excel) automatically .

Though im aware that this can be done manually , im looking if FTP can be done.. Any ideas?

Thanks
Uday

Hello,

No, it won't be automatic.

You might write a process on the desktop to download the file from the mainframe and launch excel, but there is no jcl i'm aware of that "talks" to a pc.

Regardless of what the process becomes on the pc, you will most likely use the pc to "pull" the data from the mainframe. Even if ftp can be run on your mainframe via jcl, your desktop is most likely not set up as an ftp server (most places to not support an ftp service on desktop systems).