Then, there's always:

:SELECT FILE1
xxx items selected.
>NSELECT FILE 2
yyy items selected.
>

You can also do the same as noted below with an "EVAL" command. e.g.

:select FILE1 WITH EVAL "TRANS('FILE2', @ID, 0, 0)" = ""
xxx items selected.
>

Bill

------------------------------------------------------------------------
----- Original Message -----
*From:* james.mcgo...@bankofthewest.com
*To:* U2 Users List <u2-users@listserver.u2ug.org>
*Date:* 3/3/2014 9:56 AM
*Subject:* Re: [U2] Left Outer Join Question
The usual "pick" way to do this is to create an attribute:

AE DICT FILE1 BLACKLIST
001: I
002: TRANS("FILE2", @ID, 0, 0)  ; or really old-school OCONV(@ID,"TFILE2;X;0;0")
003:
004:
005: 20L
006: S

:GET.LIST L1
1000 Items Selected
:SELECT FILE1 WITH BLACKLIST = ""
600 Items Selected




-----Original Message-----
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of randyleesmith
Sent: Monday, March 03, 2014 9:44 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Left Outer Join Question

I have 2 files.

File 2 is a black list of records (keys) I want to exclude in and active select 
list of File 1.

I've been looking into this for a little while and am not sure what I'm doing 
wrong.

Docs are not very helpful with any examples on the how to do with this.


I know of ways to deal with this in code, but was hoping for an SQL way to deal 
with it.







-----
I used to be an Optimist until I knocked over the glass.
--
View this message in context: 
http://u2-universe-unidata.1073795.n5.nabble.com/Left-Outer-Join-Question-tp42740.html
Sent from the U2 - Users mailing list archive at Nabble.com.
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
-----------------------------------------
IMPORTANT NOTICE:   This message is intended only for the addressee
and may contain confidential, privileged information.  If you are
not the intended recipient, you may not use, copy or disclose any
information contained in the message.  If you have received this
message in error, please notify the sender by reply e-mail and
delete the message.
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Reply via email to