RE: Counter on query is too small

[Mark Walter <mwalter@xxxxxxxxxxxxxxx>]

I don't see the COUNT function as being available as a result field function. Your requirements may have outdone the ability of Query/400.

There are other options available. SQL, Counting in an RPG Program, etc, etc...

Mark Walter
Business to Business Data Integration Specialist
Certified IBM System i Specialist
Paragon Consulting Services, Inc
mwalter@xxxxxxxxxxxxxxx
717-764-7909 ext. 126


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Richard Reeve
Sent: Tuesday, August 11, 2009 10:48 AM
To: Midrange Systems Technical Discussion
Subject: Re: Counter on query is too small

Don't have a system in front of me at the moment but try result fields......

Warmest Regards,

Richard Reeve




________________________________
From: Dan Rasch <drasch27@xxxxxxxxxxx>
To: midrange-l@xxxxxxxxxxxx
Sent: Tuesday, August 11, 2009 8:45:30 AM
Subject: Counter on query is too small




I wrote a query to get an expected result on a purge process I am writing.



I am expecting to purge about 50 million records.



The result of my query was



FINAL TOTALS
COUNT *********



The counter is only  7/0 and I need 8/0.



Where can the counter length be bumped?












_________________________________________________________________
Express your personality in color! Preview and select themes for Hotmail(r).
http://www.windowslive-hotmail.com/LearnMore/personalize.aspx?ocid=PID23391::T:WLMTAGL:ON:WL:en-US:WM_HYGN_express:082009
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.



--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.