HP3000-L Archives

December 1999, Week 3

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:
From:
Hans Hendriks <[log in to unmask]>
Reply To:
Hans Hendriks <[log in to unmask]>
Date:
Thu, 16 Dec 1999 09:02:06 -0800
Content-Type:
text/plain
Parts/Attachments:
text/plain (39 lines)
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
|

ATOM RSS1 RSS2