Page 1 of 1

Data from Spool to Excel sheet

PostPosted: Wed Apr 02, 2008 5:13 pm
by sankar.guna
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 ?

Re: Data from Spool to Excel sheet

PostPosted: Wed Apr 02, 2008 7:06 pm
by MrSpock
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.

Re: Data from Spool to Excel sheet

PostPosted: Thu Apr 03, 2008 9:00 am
by sankar.guna
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 ?

Re: Data from Spool to Excel sheet

PostPosted: Thu Apr 03, 2008 1:33 pm
by dick scherrer
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. . .