IBM Mainframe Forum

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).

i know my environment is capable of handling it, i am just looking for supportive JCL which can generate the data which i need.

Set of 10 Jobs
|||||||
once the last job completes the report generation job( we will add a job with our required JCL) should run and get the end / job completion time.
----> This report job has to get the end times and send email to recipients.

-----i have JCL or setup for sending email.

Need the Control M utility / the idea to get the jobs end date.

Ravichvasu wrote:i know my environment is capable of handling it, i am just looking for supportive JCL which can generate the data which i need.

Set of 10 Jobs
|||||||
once the last job completes the report generation job( we will add a job with our required JCL) should run and get the end / job completion time.
----> This report job has to get the end times and send email to recipients.

-----i have JCL or setup for sending email.

Need the Control M utility / the idea to get the jobs end date.

It is a very bad manner: posting the questions in such form:

I need to do something, I don't know what exactly, but it must work automatically.

In this case the answer can be only:

You need to do something to provide the required conversions and operations.