Re: [U2] Left Outer Join Question

Randy,

It sounds like NSELECT is what you need.
But MERGE.LIST is a handy thing to get working.
I use it all the time, especially when researching bugs or bad data.

What happens if you do other commands manipulating active select list 1?

SELECT OLDMAS TO 1
SAVE.LIST X FROM 1 ?   or  LIST OLDMAS FROM 1 ?

You say you're in Pick-flavor.
Look for "1", "2", "3" in the VOC.
There may be A-items defined there.  They may conflict with parsing the 
command.   "0" thru "11" actually.
If there are, they should be moved to DICT.DICT which, unlike true Pick, 
is UV's "master" dictionary of dictionaries.

While you're at it, for any and all of the words used in the command 
line compare your VOC to what is in NEWACC (the file they build VOCs for 
new accounts).  Particularly "TO" & "FROM".

I have seen some commands fail, but others work fine when those are not 
exactly as NEWACC says they should be.

Chuck


On 3/4/2014 3:39 PM, randyleesmith wrote:
> I tried the simplest way and still could not get it to work.
>
> SF-MORT>SELECT OLDMAS TO 1
>
> 5247 record(s) selected to SELECT list #1.
> SF-MORT>SELECT TRWMONTHEND TO 2
>
> 5229 record(s) selected to SELECT list #2.
> SF-MORT>MERGE.LIST 1 INTERSECT 2 TO 3
>
> SELECT list 1 is not active.
> SF-MORT>MERGE.LIST 1 INTERSECT 2
>
> SELECT list 1 is not active.
>
> I even tried the lowercase select and got the same result.
>
> Our version is 10.2.7 and we are running in PICK PICK.FORMAT.
> We are running a number of older applications and Proc's.
> So it may because of the Version I'm using.
>
> ----:
> 0001: X
> ----:
> 0002: 10.2.7
> ----:
> 0003: PICK
> ----:
> 0004: PICK.FORMAT
> ----:
> 0005: 10.2.7
>
>
>
> -----
> 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-tp42740p42772.html
> Sent from the U2 - Users mailing list archive at Nabble.com.
> _______________________________________________
> U2-Users mailing list
> [email protected]
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>

_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users