I'm not sure I'd combine them; handle the data once.
I'd readext through file1_list, then readnext through file2_list.
...and I'd probably use the basic select, making AMOUNT="112.50" my first
filter. Again, then you only read the data once. (Exception: if the field is
indexed, I'd go with an external select)(If AMOUNT is indexed, you probably
have too many indices...;))
> Date: Wed, 27 Jul 2011 13:15:40 -0400
> From: [email protected]
> To: [email protected]
> Subject: [U2] Doing Multiple Selects in BASIC and combining the lists
>
> This may be an easy one, or a hard one, however, I realized I don't recall
> ever having to do this until today, or I could just be tired...
>
> How can you do a SELECT from two different files in a BASIC program and then
> combine the lists of ID's so that you can do a READNEXT on it?
>
> I ask this because I believe by default that Universe does not store the
> select lists as dynamic arrays.
>
> For example:
>
> EXECUTE \SELECT FILE1 WITH AMOUNT = "112.50"\ RTNLIST FILE1_LIST
> EXECUTE \SELECT FILE2 WITH AMOUNT = "112.50"\ RTNLIST FILE2_LIST
>
> ...Code to combine FILE1_LIST and FILE2_LIST into FINAL_LIST...
>
> REANEXT ID FROM FINAL_LIST THEN
> do something
> NEXT ID
>
> I am using Universe 10.3.x on AIX 5.3. I'm in a PICK flavor account.
>
> --
> John Thompson
> _______________________________________________
> 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
