Subject: | |
From: | |
Reply To: | |
Date: | Thu, 16 Dec 1999 09:02:06 -0800 |
Content-Type: | text/plain |
Parts/Attachments: |
|
|
Leonard S. Berkowitz asked
> 1. What is the address of the Robelle-l?
To post a message, or respond to another post: mailto:[log in to unmask]
To subscribe/unsubscribe or change your preferences:
mailto:[log in to unmask]
Full details at: http://www.robelle.com/support/robelle-l.html
> 2. In Suprtool DUPLICATE RECORD ONLY:
>
> If only one field is extracted to the output file, is the RECORD ONLY
criterion
> applied only to that field or still to the entire data-base entry?
DUPLICATE ONLY RECORD is an output operation, so checks the *output* record
for "duplicateness". As such, it checks only the fields included in the
output record. This is different to using DUPLICATE ONLY KEYS, which forces
Suprtool to check all the sort keys, irrespective of whether they're
included in the output record. So if you want to check the entire input
record for duplicateness, but only extract a subset of fields, you can force
this by declaring the entire record as a sort key, then using DUP ONLY KEYS:
> get D-SALES
> define entirerecord,1,80
> sort entirerecord
> duplicate ONLY keys
> extract ......etc...
HTH
/Hans
+------------------------------------------
| Hans Hendriks Robelle Consulting Ltd
| mailto:[log in to unmask] (888) 762-3553
| http://www.robelle.com
|
|
|
|