You could delete everything in the dataset and reload it from a file which
has the duplicates removed.  Of course you should only do this when you have
exclusive access to the database.  It might take a while, but it would work.

i.e.
GET A
SORT ...
DUP N R
O FILE1,link
xeq
GET A
O FILE2,link
del
xeq
in FILE1
put A
xeq


----- Original Message -----
From: "Venkataraman Ramakrishnan" <[log in to unmask]>
To: <[log in to unmask]>
Sent: Friday, November 14, 2003 7:21 AM
Subject: [HP3000-L] Suprtool Help


Hello Everybody,

I am trying to remove non-unique duplicates in a dataset using SUPRTOOL.


I am following the approach as is given in the SUPRTOOL Manual, which
goes something like this.

Get all such non-unique records into say file-1 using dup only record.
Use dup none record on file-1 and get a file-2 which has only unique
records.
Load file-2 into a table.
But here am facing a problem. My record-length is 536 and when I try to
load the table it throws up the following error.
"Error:  TABLE only works with items <= 256 bytes long".

Any workarounds or suggestions ??

Venkat

* 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 *