IBM Mainframe Forum

Hi,

I'm new to this forum, hence I had no idea which part of the forum to post this in. Please move my post if I have posted in the wrong section.

Every day i check some job in mainframe and enter the job detail in Excel. Is there any way to export the job details to excel?

not in one click
build a csv ( comma separated values ) dataset,
download it to Your workstation
import it into Your excel sheet!

if the details are system details You can use sdsf interfaced by REXX as described here
http://www.redbooks.ibm.com/abstracts/sg247419.html

if the details are application details process the application output

Thanks for ur reply. I am new to mainframe. so can you explain how to build a csv dataset which include batch job details and also how to import it to excel?

Are you new to programming? If you are then you have a lot to learn to accomplish task.
Do you have SDSF? If not then you may not be able to do this task directly using Rexx although other spool facilities probably can export the data required to a dataset that can then be manipulated by Rexx to produce a csv dataset that can be downloaded to the PC.

shalu31 wrote:Every day i check some job in mainframe and enter the job detail in Excel. Is there any way to export the job details to excel?

Are you saying you look at one job, but have to do it every day? What data do you have to record? Are you accessing the mainframe through a Windows PC? If so, why not copy-and-paste?

If you do have lots of data to collect, are you using any sort of scheduler package? You'll probably find that there are reports from there that you might be able to use (like all the job information for all the jobs in just one report file). You might even find that someone else (amongst the techies) already has the information you need in a usable format (assuming you are talking about production jobs).

To write a program to extract a small amount of data from one programs job log each day is a bit of a sledgehammer. However, it can be good practice and give you insights into other solutions another time. However, if you just want to get on with it, I suggest you'll end up with cut-and-past or someone who already has the data.

Exactly what is was thinking. Cutting & Pasting will probably be the better solution without enough information about the infrastructure on our end to even speculate about other options.

<Moderator's Note>
I've already contacted the OP via PM about this topic, and have gone into some detail about why it's inappropriate (since it seems to deal more with Excel than anything else mainframe related) and seems to be stated more as a complex problem looking for us to provide the solution rather than a specific technical issue. This topic will be locked.

- Kevin