RE: Counter on query is too small

One option would be to split up your count into different types or
groups.

An order type example:

Select ordtyp, count(*) from ........
Group by ordtyp

Of course, you would need to figure out what field(s) you can split them
up on & if you can split them up.

Thanks.
James Salter
Systems Programmer
American Cast Iron Pipe Company
phone (205) 325-3033
fax (205) 307-3833

from: Dan Rasch <drasch27@xxxxxxxxxxx>
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?









_________Confidentiality Notice_______________________
This e-mail and any files transmitted with it is
confidential and is intended solely for the use of
the individual(s) or entity(ies) to whom this e-mail
is addressed. If you are not the intended recipient
or the person responsible for delivering the e-mail
to the intended recipient, be advised that you have
received this e-mail in error, and that any use,
disclosure, dissemination, forwarding, printing,
retention or copying of this e-mail is strictly
prohibited. If you have received this e-mail in
error, please immediately return this e-mail to
the sender and delete the e-mail from your system.
Thank you.