For lack of not knowing the right way. You could do something like; SELECT FILE SAVE.LIST TO 2 Sometime later do MERGE.LIST 2 UNION 2 TO 0 It should return the result of what is in select list 2.
Anthony > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward > Sent: Thursday, October 26, 2006 4:14 PM > To: U2-Users List > Subject: [U2] Status of multiple active lists > > > Hi Folks, > > I need to be able to test for an active list when it's not > cursor 0. In my program, I have an active list in 0 and I > want to do another select to list 2. I then need to be able > to find out if there was, indeed, records found for list 2 so > I can do a save-list or whatever. Normally I'd use > SYSTEM(11) but the documentation does not seem to specify > which list it's reporting back for. I'd be happy if I could > get a count of how many ID's are in list 2, too, but I can > live without the count. > > TIA > > Bob Woodward > Senior Programmer/Analyst > Harbor Wholesale Grocery > ------- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/