MQSeries.net :: View topic - Mainframe Reports (like Excel)

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » General Discussion » Mainframe Reports (like Excel)

Mainframe Reports (like Excel)

« View previous topic :: View next topic »

Author

Message

javagate

Posted: Thu Jan 05, 2006 4:13 am Post subject: Mainframe Reports (like Excel)

Disciple

Joined: 15 Nov 2004
Posts: 159

I would like to build a data base on the mainframe (add data each day)
andeate reports that look like a Excel spreadsheet. The goal is to automate the process. Does anyone have any ideas how someone would go about something like this? Thanks.
_________________
WebSphere Application Server 7.0 z/OS &
MQ 6.0. I work with WebSphere in the real world not in some IBM lab.

jefflowrey

Posted: Thu Jan 05, 2006 4:18 am Post subject:

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981

"look like an Excel spreedsheet" how? On the screen? Or in content?

You could use an ISAM file for the database. Then you can format the data as comma seperated records and then Excel will open the files normally.

Or if you have DB2, you could create database and insert records and then create an ODBC database connection on a windows desktop and USE Excel to view the data.
_________________
I am *not* the model of the modern major general.

javagate

Posted: Thu Jan 05, 2006 4:35 am Post subject:

Disciple

Joined: 15 Nov 2004
Posts: 159

[quote="jefflowrey"]"look like an Excel spreedsheet" how? On the screen? Or in content?
[quote]

Thanks for your input. What I am intrested in is the printed report. The ODBC connection sounds intresting. I was thinking more along the lines of wrapping code around the actual numbers and running it to get my reports.. Thanks.
_________________
WebSphere Application Server 7.0 z/OS &
MQ 6.0. I work with WebSphere in the real world not in some IBM lab.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » General Discussion » Mainframe Reports (like Excel)

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Protected by Anti-Spam ACP