Data from Spool to Excel sheet



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

Data from Spool to Excel sheet

Postby sankar.guna » Wed Apr 02, 2008 5:13 pm

Hi,

I want to move the data from the Spool to an excel sheet after sorting it using some dates and time parameters.
can anyone help me with this case ?
sankar.guna
 
Posts: 12
Joined: Wed Apr 02, 2008 5:05 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Data from Spool to Excel sheet

 

Re: Data from Spool to Excel sheet

Postby MrSpock » Wed Apr 02, 2008 7:06 pm

OK.

1.I want to move the data from the Spool ... How do you intend to do this?

2.I want to move the data ... to an excel sheet ... How do you intend to do this, bearing in mind that the layout for Microsoft Excel is a rather proprietary format, and that, I presume, this excel sheet resides somewhere else other than on the mainframe?

3.after sorting it using some dates and time parameters. We could probably help here if you'd fill in a lot more of the details.
User avatar
MrSpock
Global moderator
 
Posts: 810
Joined: Wed Jun 06, 2007 9:37 pm
Location: Raleigh NC USA
Has thanked: 0 time
Been thanked: 2 times

Re: Data from Spool to Excel sheet

Postby sankar.guna » Thu Apr 03, 2008 9:00 am

Hi MrSpock,
Thanks a lot
Sorry for the short brief..

I have a job that retrieves some data from some files and displays it in the spool in the following format.,

Countrycode x1 x2
US 12 23
UK 23 45
NL 56 90
DE 23 34

This job runs everyday and we collect the data and manually enter it into a excel sheet everyday. Now I want to automate the process.
The excel sheet will have data in the following format

Date countrycode X1 X2
3\31\2008 US 11 23
4\1\2008 US 12 23
3\31\2008 UK 22 45
4\1\2008 UK 23 45

Now i want to import the data from the spool to the excel sheet everyday ,(sorted by the current date)
Is this possible and can you help me with this ?
sankar.guna
 
Posts: 12
Joined: Wed Apr 02, 2008 5:05 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Data from Spool to Excel sheet

Postby dick scherrer » Thu Apr 03, 2008 1:33 pm

Hello,

You could write the data to a qsam file and then copy that file to the spool.

You could also ftp the file to aremote system in the same job.

There is no good reason to write the info to the spool and then try to grab it back to download. . .
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times


Return to JCL

 


  • Related topics
    Replies
    Views
    Last post