Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

How do I create a report?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Compuware & Other Tools
View previous topic :: :: View next topic  
Author Message
ajaychandraredd1

New User


Joined: 06 Jun 2008
Posts: 8
Location: Minnieapolis

PostPosted: Sat Jun 07, 2008 9:19 am    Post subject: How do I create a report?
Reply with quote

I was asked to create a report. For example using ICN Number. Which tool do I need to use. Is it FileAid?

Thank You,
Ajay
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sat Jun 07, 2008 9:34 am    Post subject:
Reply with quote

Hello Ajay and welcome to the forums,

You need to provide much more info for anyone to be able to help you.

ICN is your term - not necessarily known to most people here.

We cannot tell you which tool to use. We can tell you that excel spreadsheets are not created on the mainframe. You can create a file that could be loaded into a spreadsheet, but spreadsheet files are not created from typical applicatioin programs.

Why might you think of creating a report with fileaid or ftp?

I believe you need to get much better direction from whoever "asked you to create a report".

Also, please do not post the same question multiple times - the other post has been deleted.
Back to top
View user's profile Send private message
ajaychandraredd1

New User


Joined: 06 Jun 2008
Posts: 8
Location: Minnieapolis

PostPosted: Sat Jun 07, 2008 10:59 am    Post subject: Reply to: How do I create a report?
Reply with quote

Hi,

Can you please let me know what are the genuine questions that i would need to ask? Because it is in production region i am afraid that i might mess-up something.

The following is the scenario

I work in a healthcare project and ICN Number is Internal Control Number which is the number used to uniquely identify the claim. Now using this number i have create a report for all the possible ICN Numbers.

Sorry about positing in multiple place, because i was not sure which tool to use i thought it might be helpful.

Thank You
Ajay
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10232
Location: italy

PostPosted: Sat Jun 07, 2008 12:01 pm    Post subject: Reply to: How do I create a report?
Reply with quote

Quote:
Which tool do I need to use.


what is the standard tool to write reports in Your organization ?

the software to be used depends on the complexity of the report...

just a list of possible softwares which could be used

sort ( DFSORT/SYNCSORT and relative add on tools)
FILEAID ( You quoted it but I do not know anything about its reporting capabilities )
EASYTRIEVE
SAS
a user program ( COBOL, PL/I )

Your question is really too generic to receive a good answer

why not ask somebody of Your team for the details of your environment
and the common practices for such a task ?
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sat Jun 07, 2008 12:21 pm    Post subject:
Reply with quote

Hello,

Quote:
Because it is in production region i am afraid that i might mess-up something.
It is good to be careful of the production environment, but it should not be that fragile. Adding a report should not mess things up - and testing should be done in a test environment . . .

Quote:
Sorry about positing in multiple place, because i was not sure which tool to use i thought it might be helpful.
Not to worry - you didn't know and now you do. Something that would be a good thing to do is to read the forum rules (it is mentoned there). Once your requirement "stabilizes" we can move your topic to a more appropriate section of the forum.
http://ibmmainframes.com/board_rules.php

Quote:
Now using this number i have create a report for all the possible ICN Numbers.
I suspect that more than just this number is needed on the new report. So, first you need to get direction on which information should be on the report, the sequence of the report (unless it is simply a list in ICN sequence), and which (if any) totals are needed.

Where is the data stored? Tape, sequential dasd, vsam, some database? This may influence the choice of reporting tool used.

Most organizations have one or only a few standard production reporting tools. If this is the case, you need to pick one that is acceptable to your organization for promotion to production.

Knowing the source of the data, the report requirements, and the rules of your organization will help pick a reporting tool.

If your new report is being created for loading into a spreadsheet, you may not want a report at all, but rather a delimited file that can be easily downloaded for use with spreadsheet software.
Back to top
View user's profile Send private message
ajaychandraredd1

New User


Joined: 06 Jun 2008
Posts: 8
Location: Minnieapolis

PostPosted: Sat Jun 07, 2008 11:37 pm    Post subject: Reply to: How do I create a report?
Reply with quote

Hi,

The source of the data is VSAM Files.

Thank You,
Ajay
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sun Jun 08, 2008 1:18 am    Post subject:
Reply with quote

Hello,

Quote:
The source of the data is VSAM Files.
Ok. With luck the needed data will be pulled from a single vsam file rather than joining multiple files. Someone there needs to define which file(s) each field is to be retrieved from.

Which tool(s) should be used to process against a vsam file on your system? Only someone in your organization can answer this (we don't know your environment or rules).

You need to also determine if you are going to create a "report" or a file suitable for downloading or both. Again, this decision must come from within your organization.

Once you and your group have defined the requirement, we may be able to provide implementation suggestions. From the very little you have provided, we cannot help with the requirement definition (we don't usually deal with the requirement definition, but rather with ways to deliver the requirement or help with technical questions).

Keep in mind that your topic so far has been like someone asking "Which is the best way to get to the store?". Well, which store or even which kind of store, in which city/country? Are you walking, driving, taking a bus or using some other transportation? Without better info, no good answer is possible.
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Sun Jun 08, 2008 6:53 pm    Post subject:
Reply with quote

Hi,

Pehaps if you'll analyse some reporting-program at your shop, that would guide you better, at least can provide you a base. What 's the final report expected, is that known to you ..the information provided so far is too little to suggest something via a forum.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Compuware & Other Tools All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Splitting of single report to seperat... abdulrafi TSO/ISPF 4 Mon Mar 27, 2017 3:59 pm
No new posts Easytrieve report shalem CA Products 4 Sun Feb 26, 2017 9:08 am
This topic is locked: you cannot edit posts or make replies. Rexx to create GDG by scanning JJ result krish.deepu CLIST & REXX 5 Tue Oct 25, 2016 5:32 pm
No new posts Detailed Transaction History report f... Kyle Carroll CICS 5 Tue Oct 18, 2016 12:42 am
No new posts How can we create a flat file in JAVA... rakesh.v18 Java & MQSeries 7 Fri Sep 23, 2016 10:46 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us