Big Iron <[EMAIL PROTECTED]> wrote on 04/06/2006 09:02:43 AM:
> Sounds like a job for the SPLICE operator.
Actually, SELECT is better in this case (see my previous post).
But SPLICE can be used for more complex types of matching (and joining).
Frank Yaeger - DFSORT Team (IBM)
Specialties: ICETOO
[EMAIL PROTECTED] wrote:
> I am trying to find an efficient way to get a
> complement of to datasets. As result I expect
> the records that appear in FILEA but not in
> FILEB.
>
> Example dataset:
>
> FILEA:
> record a
> record b
> record c
> record d
> record e
>
> FILEA:
> record a
> record b
> r
Sounds like a job for the SPLICE operator.
Bill
[EMAIL PROTECTED] wrote:
> I am trying to find an efficient way to get a
> complement of to datasets. As result I expect
> the records that appear in FILEA but not in
> FILEB.
>
> Example dataset:
>
> FILEA:
> record a
> record b
> record c
> record
3 matches
Mail list logo