Report Generation

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

Report Generation

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


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?

Posts: 29
Joined: Fri Feb 06, 2009 6:13 am
Has thanked: 0 time
Been thanked: 0 time

Re: Report Generation


Re: Report Generation

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


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,
User avatar
dick scherrer
Global moderator
Posts: 6308
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 90 times

Return to JCL


  • Related topics
    Last post