Any tool that exports data from Mainframes to Excel sheet?

Ask questions about any other mainframe topics which are not covered above

Moderator: Moderator Group

Post Reply
pullaiah.cts
Member
Posts: 4
Joined: Sat Jun 04, 2011 1:03 pm
Location: Hyderabad

Any tool that exports data from Mainframes to Excel sheet?

Post by pullaiah.cts » Sun Sep 04, 2011 10:41 pm

Hi All,

In our project, I used to run the DB2 queries and prepare the transaction reports as per the given details like Client id,transaction date...etc.
I follow the below steps to create the reports:
1.Run the DB2 queries
2.Execute the COBOL program to seperate each columns with a delimiter.
3.Download the data from Mainframes to a text file
4.Then, export the data to a excel sheet and format it.

But,there is much time wasting by downloading it to text file and again export it to Excel sheet.So,I am looking for way to export the data from mainframe to Excel sheet directly.

Can anyone please let me know the tools that are used to export the data to excel sheets directly? I found a tool called 'Spectrum Mainframe Exporter' which can satisy my requirement but it's licence is too expensive,we cannot bear that much amount.

Any other tool which will satisy my requirement with less amount?

Thanks in advance!!!!!
Thanks,
Pullaiah

DikDude
Moderator
Posts: 1001
Joined: Fri Jul 22, 2011 8:39 am
Location: usa

Post by DikDude » Mon Sep 05, 2011 9:30 am

You already have this topic active in another forum. . .

If we find another topic double-posted you will most likely be banned from that forum. . . :(

Any given question should only be posted one time. As most of the same "seniors" answer most forums, this just wastes their time.

pullaiah.cts
Member
Posts: 4
Joined: Sat Jun 04, 2011 1:03 pm
Location: Hyderabad

Post by pullaiah.cts » Mon Sep 05, 2011 11:15 am

Thanks for information,sorry for the duplicate post.
Thanks,
Pullaiah

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others