Page 1 of 1

Report Generation

PostPosted: Thu Mar 05, 2009 3:02 am
by uday123
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

Re: Report Generation

PostPosted: Thu Mar 05, 2009 3:49 am
by dick scherrer
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).

Re: Report Generation

PostPosted: Wed Aug 09, 2023 3:01 pm
by Ravichvasu
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.

Re: Report Generation

PostPosted: Wed Aug 09, 2023 5:07 pm
by sergeyken
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.