Deleting duplicates from detail sets

[jlkeepers@mmm.com]

Benny,

Here is a QTP example removes duplicate occurances of ELEMENT_A from FILE_A

REQ STEP1
SET PROCESS LIMIT 200000 LOCK FILE REQUEST
ACCESS FILE_A
SORT ON ELEMENT_A
SUB DUPFILE AT ELEMENT_A KEEP INCLUDE ELEMENT_A
;
Req STEP2
ACCESS  *DUPFILE link to FILE_A
SELECT IF ELEMENT_A OF TESTDUP = ELEMENT_A OF FILE_A
SORTED ON ELEMENT_A
TEMP X NUM*2
ITEM X COUNT RESET AT ELEMENT_A OF DUPFILE
OUTPUT FILE_A DELETE IF X > 1 ON ERRORS REPORT

Jeff Keepers
3M Valley, NE




"Benny Møller, ScanConsult" <bm@scanconsult.dk> on 08/23/2000 09:11:56 AM


To:   "PowerHouse List" <powerh-l@sphere.swau.edu>
cc:    (bcc: Jeff L. Keepers/VQ-Valley/3M/US)
Subject:  Deleting duplicates from detail sets



Hi list

I am currently working on a problem regarding duplicate records in detail
sets. But i have a problem when it comes to deleting the duplicates, leaving
one of each in the database.
Does any of you have a solution?

My system is HP3000 MPE/iX 5.5, PH version 8.19.C4


TIA

Benny Møller

====================================================================
E-mail: bm@scanconsult.dk                Cell Phone: +45 23 43 89 67
====================================================================
ScanConsult IT-Partners                    Voice   : +45 87 34 55 07
Udviklingsparken Aarhus                    Fax     : +45 87 34 15 07
Soenderhoej 46                      Support : support@scanconsult.dk
DK-8260 Viby J.                     Sales   :   sales@scanconsult.dk
Denmark                             Web  : http://www.scanconsult.dk
===     M A C H  :  Menu-based  Air  Cargo  Handling  system     ===
===       ScanConsult is Authorized by Hewlett-Packard as:       ===
===     *    HP 3000 Select Independent Software Vendor    *     ===
===     **             HP9000  Power  Partner             **     ===

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.




= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.