Thanks for the help. You guys are way better than typing in the word "LIST" in the pdf manuals and hoping to find what you are looking for :)
On Wed, Jul 27, 2011 at 1:26 PM, Dan Fitzgerald <[email protected]>wrote: > > 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 > -- John Thompson _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
