RE: Counter on query is too small

[Dan Rasch <drasch27@xxxxxxxxxxx>]

Perfect.

 

Thank you.
 
> From: casey_r@xxxxxxxxxxxxxxxx
> To: midrange-l@xxxxxxxxxxxx
> Subject: RE: Counter on query is too small
> Date: Tue, 11 Aug 2009 11:50:33 -0400
>
> Under "Define result fields", create a field:
>
> Field = COUNTER
> Expression = 1
> Len = 8
> Dec = 0
>
> Use the COUNTER field in your "Select and sequence fields"
>
> Use the Total function (1) for the COUNTER field in "Select report summary
> functions"
>
> Use Summary only (2) for the form of output on "Select output type and
> output form"
>
> Happy counting!
>
> Richard
>
>
>
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Mark Walter
> Sent: Tuesday, August 11, 2009 11:09 AM
> To: Midrange Systems Technical Discussion
> Subject: RE: Counter on query is too small
>
> 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.
>
> -- 
> 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.

_________________________________________________________________
Get free photo software from Windows Live
http://www.windowslive.com/online/photos?ocid=PID23393::T:WLMTAGL:ON:WL:en-US:SI_PH_software:082009