Yea, MERGE.LIST does work, but sometimes I have issues with it using it in an EXECUTE from BASIC.
George Actually, you could leave off the TO 3, and the FROM 3 and it would still work. The only disadvantage, is MERGE.LIST ALWAYS does a distinct, and you can't use it to merge on More than one field, whereas in a JOIN you can. George -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Wednesday, October 17, 2012 10:29 AM To: 'U2 Users List' Subject: Re: [U2] Selection Suggestions for using UV instead of SQL This gets a little trickier, but how about: 1) SELECT PEOPLE TO 1. 2) SELECT REGISTRATION WITH EID = '1' SAVING UNIQUE PID. 3) SELECT PEOPLE TO 2. 4) MERGE.LIST 1 DIFF 2 TO 3. 5) SAVE.LIST XXX FROM 3. This does assume that steps 1 and 2 actually return at least 1 key. MERGE.LIST is an amazingly powerful command. It only works with the native UniData (UniVerse?) syntax as do the specific list #s, but it is easy enough to use the lower case verbs to force the individual commands to run in native mode. John -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Wednesday, October 17, 2012 10:20 AM To: U2 Users List Subject: Re: [U2] Selection Suggestions for using UV instead of SQL That was my first try, but the NSELECT only checks PEOPLE for those that are in the list returned by the first That are not in PEOPLE, it doesn't check for those in PEOPLE that are not in the list returned. George -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Wednesday, October 17, 2012 10:05 AM To: 'U2 Users List' Subject: Re: [U2] Selection Suggestions for using UV instead of SQL Do it in more than one command? SELECT REGISTRATION WITH EID = '1' SAVING UNIQUE PID NSELECT PEOPLE Or am I missing something? John -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Wednesday, October 17, 2012 9:59 AM To: U2 Users Subject: [U2] Selection Suggestions for using UV instead of SQL Ok. I have file1 - "people" that has @ID of PID I have file2 - "registration" that has @ID of PID+EID+RID (EID = event id, RID = registration id) I want to select people who are not in the registration file with an EID of "1". With an SQL statement - I could join the two, then do the select or use a subquery (I'm on UV 10.0.2 - not sure if sub querys work) Just curious how this could be done with UV Native, and without involving a program. I first tried "SELECT REGISTRATION WITH EID = '1' SAVING UNIQUE PID" -> "NSELECT PEOPLE" But that returned 0 - since the NSELECT only works off the current select list, not the whole file Yes, I could create a temporary file, then select off that Yes, I could read each people record, then loop through registration to see if it doesn't exist. Both of the above require programming I guess I could create a subroutine that does the looping through registration, and put that into an I descriptor - looking for another option. George _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
