In a nutshell SELECT FILE WITH VALUE = 'A' TO 1 SELECT FILE WITH VALUE = 'B' TO 2 MERGE.LIST 1 UNION 2 TO 0 SORT FILE VALUE
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of John Thompson Sent: Wednesday, July 27, 2011 12:16 PM To: U2 Users List 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
