Report Generation



JES, JES2, JCL utilities, IDCAMS, Compile & Run JCLs, PROCs etc...

Report Generation

Postby uday123 » Thu Mar 05, 2009 3:02 am

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
uday123
 
Posts: 29
Joined: Fri Feb 06, 2009 6:13 am
Has thanked: 0 time
Been thanked: 0 time

Re: Report Generation

Postby dick scherrer » Thu Mar 05, 2009 3:49 am

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).
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: Report Generation

Postby Ravichvasu » Wed Aug 09, 2023 3:01 pm

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
 
Posts: 2
Joined: Fri Aug 04, 2023 9:24 am
Has thanked: 0 time
Been thanked: 0 time

Re: Report Generation

Postby sergeyken » Wed Aug 09, 2023 5:07 pm

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.
Javas and Pythons come and go, but JCL and SORT stay forever.
User avatar
sergeyken
 
Posts: 408
Joined: Wed Jul 24, 2019 10:12 pm
Has thanked: 6 times
Been thanked: 40 times


Return to JCL

 


  • Related topics
    Replies
    Views
    Last post