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
 

 

Tally the number of items in report

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CA Products
View previous topic :: :: View next topic  
Author Message
cvadlamudi

New User


Joined: 19 Apr 2007
Posts: 68
Location: India

PostPosted: Mon Mar 23, 2009 3:23 pm    Post subject: Tally the number of items in report
Reply with quote

Hi,

I have a report with a list of detail lines, which includes Account numbers and Amounts with other information. I have to include the Count of Total number of Account numbers in the report. Each Account number may or may not have duplicates. Similar to Tally is there any other option.

EX:
A/C
000122
000122
000122
000233
000444
000444
000555
000555

The Count should be 4

Thanks in Advance


Thanks,
Mouli.V
Back to top
View user's profile Send private message

anandinmainframe

Active User


Joined: 31 May 2007
Posts: 171
Location: India

PostPosted: Mon Mar 23, 2009 3:49 pm    Post subject: Reply to: Tally the number of items in report
Reply with quote

Mouli,
Can we have the sort as the first step.
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


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

PostPosted: Mon Mar 23, 2009 3:52 pm    Post subject:
Reply with quote

Hi,

This post is in CA-Products part of the forum, so not sure if you can use Sort? If yes, which sort product is in use at your shop?
Back to top
View user's profile Send private message
cvadlamudi

New User


Joined: 19 Apr 2007
Posts: 68
Location: India

PostPosted: Mon Mar 23, 2009 3:53 pm    Post subject: Reply to: Tally the number of items in report
Reply with quote

Yes, but how the Sort will get the count ?

Thanks,
Mouli.V
Back to top
View user's profile Send private message
anandinmainframe

Active User


Joined: 31 May 2007
Posts: 171
Location: India

PostPosted: Mon Mar 23, 2009 4:19 pm    Post subject: Reply to: Tally the number of items in report
Reply with quote

Mouli,
This might be helpful to you.
http://www.ibmmainframes.com/about19056.html
Back to top
View user's profile Send private message
cvadlamudi

New User


Joined: 19 Apr 2007
Posts: 68
Location: India

PostPosted: Mon Mar 23, 2009 4:28 pm    Post subject: Reply to: Tally the number of items in report
Reply with quote

Hi,

Sort or any other utility is not needed here, Since i am trying to create a report using EZT and have to display the count in the report.

Thanks,
Mouli.V
Back to top
View user's profile Send private message
anandinmainframe

Active User


Joined: 31 May 2007
Posts: 171
Location: India

PostPosted: Mon Mar 23, 2009 4:41 pm    Post subject: Reply to: Tally the number of items in report
Reply with quote

Mouli,
Whether you will have the records in the same order as mentioned in OP i.e) Duplicates followed by the original values. if yes Move the Acc no to a working storage and then compare your Working storage and the input record(Acc no) if they are same then don't increment the value(Working storage for count) for input count if not then increment the value by 1. at last EOF display that working storage.
Back to top
View user's profile Send private message
cvadlamudi

New User


Joined: 19 Apr 2007
Posts: 68
Location: India

PostPosted: Mon Mar 23, 2009 4:51 pm    Post subject: Reply to: Tally the number of items in report
Reply with quote

No, i am looking for an option similar to TALLY
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 -> CA Products All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Report cost in CA-dispatch Nileshkul CA Products 3 Wed Jun 07, 2017 10:32 pm
No new posts INREC PARSING and dictionary items migusd SYNCSORT 6 Fri Jun 02, 2017 8:02 pm
No new posts SMTP the current generation number of... Jyothi Kulunde JCL & VSAM 4 Thu May 04, 2017 4:08 pm
No new posts Edit large number of datasets (QSAM) zh_lad TSO/ISPF 3 Tue Apr 04, 2017 6:08 pm
No new posts how to mask the phone number kumarinfy DB2 4 Mon Apr 03, 2017 5:23 pm


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