[Download-List] Using TOTAL COUNTER

Minatra, Pat minatrae at hsutx.edu
Wed May 3 14:16:04 EDT 2006


I can do the following:
-----start snip
:GET.LIST SBAB.TOTAL
56 records retrieved to list 0.
>SELECT PAYTODAT WITH PTD.BD.CODES = "RRSB"
 
56 records selected to list 0.
 
>CLS
:GET.LIST SBAB.TOTAL
56 records retrieved to list 0.
>SELECT PAYTODAT WITH PTD.BD.CODES = "RESB"
 
43 records selected to list 0.

> 
-----end snip

The two responses that I get where XX records selected to list 0 are the
numbers that I need to add together and put into a variable that
DOWNLOAD will recognize.

I.E.
56 records selected to list 0.
43 records selected to list 0.
--
99 total contributions (even though there are 56 records)

I know that I can do this in basic but this is the ONLY part of this
that does not work like it use to back in R16 days.

This is a vendor requirement and so far the ONLY solution is to manually
input this number prior to submittal and that is just not a very good
solution.

Thanks for any help and have a GREAT day!

-------------------------
"Life is but a twinkle in the eye of eternity"
"The shortest distance between a problem and a solution is the distance
between your knees and the floor"
"sorrow looks back - worry looks around - faith looks up"
Regards,
Pat H. Minatra - N5GJR
(325) 670-5804 voice
(325) 670-1570 fax
Hardin*Simmons University  
www.hsutx.edu
PO BOX 16040
Abilene, TX  79698

-----Original Message-----
From: download-list-bounces at cedarville.edu
[mailto:download-list-bounces at cedarville.edu] On Behalf Of Minatra, Pat
H.
Sent: Tuesday, May 02, 2006 8:01 AM
To: download-list at cedarville.edu
Subject: [Download-List] Using TOTAL COUNTER

I wrote a paragragh in UniData in 2001 whereby I am taking data and
placing it into three different files and then concatenating it into one
file as a final submittal file to be used as electronic submittal.

The TOTAL COUNTER process use to count the contributions and now ONLY
counts records.

Example:

A record can have an employer contribution (always) and MAYBE an
employee contribution.

I was using the TOTAL COUNTER to total how total contributions (not
records) were actually made; 25 records, employer contributes 25 times,
employees contribute only 12, toal would be 37 but TOTAL COUNTER now
reports 25 and use to report 37.  I have not changed the code but the
counting 'result' changed in 2003 (which is the SAME time we came up on
R17 but that should not have made a difference).

So, my question is...is there some keyword I can use to be able to get
this number and report the number out to the third file which uses this
'total' number of contributions and not line items.

Thank you so much for any and all help.  Have a GREAT day!

-------------------------
"Life is but a twinkle in the eye of eternity"
"The shortest distance between a problem and a solution is the distance
between your knees and the floor"
"sorrow looks back - worry looks around - faith looks up"
Regards,
Pat H. Minatra - N5GJR
(325) 670-5804 voice
(325) 670-1570 fax
Hardin*Simmons University  
www.hsutx.edu
PO BOX 16040
Abilene, TX  79698

_______________________________________________
download-list mailing list
download-list at cedarville.edu
http://mail.cedarville.edu/mailman/listinfo/download-list




More information about the download-list mailing list