Re: [U2] Can this Selection be done? Either UV or SQL?
The LSELECT is actually from IBM/Rocket and can be found here: https://u2devzone.rocketsoftware.com/accelerate/articles/u2-select/u2-select kebbon.irwin wrote: > > > I think if you look up old posts on LSELECT, you may find an acceptable > answer. It is a program that creates and uses work files, but once > written, it works like a verb. I got it from the list and now use it > regularly > Cheers, > Kebbon > > > > - Learn and Do Excel and Share http://mvdbs.com http://mvdbs.com -- View this message in context: http://old.nabble.com/Can-this-Selection-be-done--Either-UV-or-SQL--tp32227537p32244342.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Can this Selection be done? Either UV or SQL?
I think if you look up old posts on LSELECT, you may find an acceptable answer. It is a program that creates and uses work files, but once written, it works like a verb. I got it from the list and now use it regularly Cheers, Kebbon > From: ggal...@wyanokegroup.com > To: u2-users@listserver.u2ug.org > Date: Tue, 9 Aug 2011 16:15:23 -0500 > Subject: Re: [U2] Can this Selection be done? Either UV or SQL? > > I found something about this on an old U2ug post from a few years ago. > > > I do it in a similar way... > > SELECT @ID FROM EINVOICES WHERE iInvoiceRef IN (SELECT EVAL "@RECORD" > FROM &SAVEDLISTS& 'INV.REF.LIST'); > > ... But I agree there should be a more "natural" way of doing this. > > Perry Taylor > - > > > -Original Message- > > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > > boun...@listserver.u2ug.org] On Behalf Of George Gallen > > Sent: Tuesday, August 09, 2011 12:43 PM > > To: U2 Users List > > Subject: Re: [U2] Can this Selection be done? Either UV or SQL? > > > > Is there anyway to : > > > > SELECT ID FROM CUSTOMERS WHERE CITY IN (GETLIST LISTNAME); > > > > To avoid having to put the list into a scratch file > > > > George > > > > > -Original Message- > > > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > > > boun...@listserver.u2ug.org] On Behalf Of Holt, Jake > > > Sent: Tuesday, August 09, 2011 12:29 PM > > > To: U2 Users List > > > Subject: Re: [U2] Can this Selection be done? Either UV or SQL? > > > > > > You can use IN > > > > > > SELECT id from customers where city IN (select cityname from cities > > > where state='MN'); > > > > > > > > > > > > -Original Message- > > > From: u2-users-boun...@listserver.u2ug.org > > > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George > > > Gallen > > > Sent: Tuesday, August 09, 2011 11:09 AM > > > To: U2 Users List > > > Subject: [U2] Can this Selection be done? Either UV or SQL? > > > > > > ok. I have a select list of values. > > > > > > Is there a way to select a file and return all ID's that contain an > > > item > > > with a field that matches one of the values in a select list? > > > > > > At least from the command line, and not have to write a program. > > > > > > > > > George Gallen > > > Senior Programmer/Analyst > > > Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com > > > ph:856.848.9005 Ext 220 > > > The Wyanoke Group > > > http://www.wyanokegroup.com > > > > > > > > > > > > ___ > > > 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
Re: [U2] Can this Selection be done? Either UV or SQL?
I found something about this on an old U2ug post from a few years ago. I do it in a similar way... SELECT @ID FROM EINVOICES WHERE iInvoiceRef IN (SELECT EVAL "@RECORD" FROM &SAVEDLISTS& 'INV.REF.LIST'); ... But I agree there should be a more "natural" way of doing this. Perry Taylor - > -Original Message- > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > boun...@listserver.u2ug.org] On Behalf Of George Gallen > Sent: Tuesday, August 09, 2011 12:43 PM > To: U2 Users List > Subject: Re: [U2] Can this Selection be done? Either UV or SQL? > > Is there anyway to : > > SELECT ID FROM CUSTOMERS WHERE CITY IN (GETLIST LISTNAME); > > To avoid having to put the list into a scratch file > > George > > > -Original Message- > > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > > boun...@listserver.u2ug.org] On Behalf Of Holt, Jake > > Sent: Tuesday, August 09, 2011 12:29 PM > > To: U2 Users List > > Subject: Re: [U2] Can this Selection be done? Either UV or SQL? > > > > You can use IN > > > > SELECT id from customers where city IN (select cityname from cities > > where state='MN'); > > > > > > > > -Original Message- > > From: u2-users-boun...@listserver.u2ug.org > > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George > > Gallen > > Sent: Tuesday, August 09, 2011 11:09 AM > > To: U2 Users List > > Subject: [U2] Can this Selection be done? Either UV or SQL? > > > > ok. I have a select list of values. > > > > Is there a way to select a file and return all ID's that contain an > > item > > with a field that matches one of the values in a select list? > > > > At least from the command line, and not have to write a program. > > > > > > George Gallen > > Senior Programmer/Analyst > > Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com > > ph:856.848.9005 Ext 220 > > The Wyanoke Group > > http://www.wyanokegroup.com > > > > > > > > ___ > > 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
Re: [U2] Can this Selection be done? Either UV or SQL?
Is there anyway to : SELECT ID FROM CUSTOMERS WHERE CITY IN (GETLIST LISTNAME); To avoid having to put the list into a scratch file George > -Original Message- > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > boun...@listserver.u2ug.org] On Behalf Of Holt, Jake > Sent: Tuesday, August 09, 2011 12:29 PM > To: U2 Users List > Subject: Re: [U2] Can this Selection be done? Either UV or SQL? > > You can use IN > > SELECT id from customers where city IN (select cityname from cities > where state='MN'); > > > > -Original Message- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George > Gallen > Sent: Tuesday, August 09, 2011 11:09 AM > To: U2 Users List > Subject: [U2] Can this Selection be done? Either UV or SQL? > > ok. I have a select list of values. > > Is there a way to select a file and return all ID's that contain an > item > with a field that matches one of the values in a select list? > > At least from the command line, and not have to write a program. > > > George Gallen > Senior Programmer/Analyst > Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com > ph:856.848.9005 Ext 220 > The Wyanoke Group > http://www.wyanokegroup.com > > > > ___ > 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
Re: [U2] Can this Selection be done? Either UV or SQL?
You can use IN SELECT id from customers where city IN (select cityname from cities where state='MN'); -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Tuesday, August 09, 2011 11:09 AM To: U2 Users List Subject: [U2] Can this Selection be done? Either UV or SQL? ok. I have a select list of values. Is there a way to select a file and return all ID's that contain an item with a field that matches one of the values in a select list? At least from the command line, and not have to write a program. George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.com ___ 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