HP3000-L Archives

October 2004, Week 4

HP3000-L@RAVEN.UTC.EDU
Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
Re: Suprtool question
From:
Tracy Pierce <[log in to unmask]>
Reply To:
Tracy Pierce <[log in to unmask]>
Date:
Thu, 28 Oct 2004 16:03:26 -0700
Content-Type:
text/plain
Parts/Attachments:
text/plain (56 lines) 
rtfm, and in this case, the f actually does stand for fine!

do you want to clobber the originals or just their duplicates?

>in parts
>sort partno
>duplicate only record
>o dups
>x
gets you ALL the duplicated records, none that aren't, and the entire
records must match.

Tracy Pierce

> -----Original Message-----
> From: Newton, Ernie [mailto:[log in to unmask]]
> Sent: Thursday, October 28, 2004 3:42 PM
> To: [log in to unmask]
> Subject: Suprtool question
>
>
> Greetings,
>
> I have some duplicate keys that I need to extract
> and delete.
>
> When I used the command "DUPLICATE ONLY KEYS"
> and execute, it finds all those duplicates, which
> is a good thing.
>
> When I do this...
> .
> .
> DUPLICATE NONE KEYS
> OUTPUT NEWFILE,LINK
> DEL
> X
> .
> .
>
> Suprtool comes back and asks me if I really want to delete
> ALL entries in the dataset, which of course, I don't want
> to do.  I was thinking that I could use the DUPLICATE statement
> in lieu of an IF statement. Am I wrong in my thinking?
>
> Thanks
>
> Ernie
>
> * To join/leave the list, search archives, change list settings, *
> * etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
>

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

ATOM RSS1 RSS2