Re: HVH duplicate record

[MacWheel99@xxxxxxx]

>  From:    haluska@biotika.sk (Peter Haluska)
>  
>  Hi all,
>  
>  please, help me how to find duplicate record in HVH. 
>  How long run PUR910? I have bad feeling, that in me case PUR910 run in
>  loop.
>  
>  Thanks
>  Peter

Quick & dirty approach
... Use DSPFFD against logicals to get at the index keys to the file
Create a Totals Only Query that COUNTS how many hits on each unique 
identification
Send that output to a Query *OUTFILE
From the work file, print only the records with count greater than one

I am not sharp on SQL - there may be an easier way 

MacWheel99@aol.com (Alister Wm Macintyre) (Al Mac)
AS/400 Data Manager & Programmer for BPCS 405 CD Rel-02 mixed mode (twinax 
interactive & batch) @ http://www.cen-elec.com Central Industries of 
Indiana--->Quality manufacturer of wire harnesses and electrical 
sub-assemblies - fax # 812-424-6838

+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---