Re: query question

This is a multipart message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
Have you tried sorting on your unique field(s), breaking on them, then
doing a count?
eg if you were duplicating;

ITEM01
        Count 1
ITEM02
ITEM02
        Count 2
ITEM03
        Count 1

Repeat as necessary for your other fields.
You could consider sending the output to an outfile then query that
outfile for where the COUNT is GT 1.

Steven Donnellan
AS/400 Systems Manager
IBM Certified Specialist - AS/400 Professional Operator
Simon Jersey Ltd

http://www.simonjersey.com




Doug Johnson <djohnson@Univbkstr.com>
Sent by: midrange-l-admin@MIDRANGE.COM
28/09/01 16:28
Please respond to midrange-l


        To:     "'midrange-l@midrange.com'" <midrange-l@midrange.com>
        cc:
        Subject:        query question



Greetings,

I need to find out if records are being posted twice to an inventory
file-and query is all that I have to work with.
Is there a way to use query to select records from a file based on the
fact
that the data in several fields is identical to the data in those fields
in
another record when in fact that combination of fields should be unique in
the file?

Thanks,

Doug

**********************************************
DOUGLAS JOHNSON
System Administrator
The University Book Store
711 State Street
Madison, WI 53703

djohnson@univbkstr.com
608-257-3784
608-257-9479 (fax)

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


--