RE: [U2] OK...Is there a way....UV
It is true that the sample is the first execution before the sorting takes place. Oracle DB dose the same thing. I was unsuccessfully trying to use sub-query in this case. Kathy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward Sent: Thursday, May 25, 2006 6:36 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] OK...Is there a wayUV Played around a bit and figured out that SSELECT adds BY @ID to the end of the select attributes, hence SSELECT FILE BY @ID is redundant. SSELECT FILE BY F2 is equivalent to SELECT FILE BY F2 BY @ID. In any case, it appears that SAMPLE has a higher execution priority in R/LIST processing, thereby forcing multiple lines in George's paragraph. Sorry George. BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brad Davis Sent: Thursday, May 25, 2006 2:40 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] OK...Is there a wayUV Use two statements: 1SSELECT FILE BY @ID 2SELECT FILE SAMPLE 2 Or 1SELECT FILE SAMPLE 2 2SSELECT FILE BY @ID -Original Message- From: Bob Woodward [mailto:[EMAIL PROTECTED] Sent: Thursday, May 25, 2006 4:11 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] OK...Is there a wayUV Have you tried: SORT FILE SAMPLE 2 BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Gallen Sent: Thursday, May 25, 2006 12:16 PM To: u2-users@listserver.u2ug.org Subject: [U2] OK...Is there a wayUV I want to sort a file by @ID and only take the first two items... SELECT FILE BY @ID SAMPLE 2 doesn't work, it first takes the sample of 2, then sorts it. SELECT FILE BY @ID SELECT FILE SAMPLE 2 works, but takes two lines How can I phrase my SELECT so it will sort first, then sample later, instead of sample first, sort later? I'm running UV. George George Gallen Senior Programmer/Analyst Accounting/Data Division [EMAIL PROTECTED] ph:856.848.1000 Ext 220 SLACK Incorporated - Delivering the best in health care information and education worldwide. http://www.slackinc.com --- 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/ --- 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] OK...Is there a way....UV
What about SSELECT FILE FIRST 2? Thanks, Nick Cipollina -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, May 25, 2006 9:03 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] OK...Is there a wayUV ED DICT FILE REC.COUNT 001 I 002 @RECCOUNT 003 004 Cnt 005 5R 006 S SORT FILE WITH REC.COUNT 2 N'es pas? __ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Gallen [EMAIL PROTECTED] Sent: Friday, 26 May 2006 05:16 To: u2-users@listserver.u2ug.org Subject: [U2] OK...Is there a wayUV I want to sort a file by @ID and only take the first two items... SELECT FILE BY @ID SAMPLE 2 doesn't work, it first takes the sample of 2, then sorts it. SELECT FILE BY @ID SELECT FILE SAMPLE 2 works, but takes two lines How can I phrase my SELECT so it will sort first, then sample later, instead of sample first, sort later? I'm running UV. George George Gallen Senior Programmer/Analyst Accounting/Data Division [EMAIL PROTECTED] ph:856.848.1000 Ext 220 SLACK Incorporated - Delivering the best in health care information and education worldwide. http://www.slackinc.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- 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/
Re: [U2] OK...Is there a way....UV
FIRST is a synonym for SAMPLE. And that example won't return the first two of the sorted file. The reccount item is a better way to go. Rog. Nick Cipollina wrote: What about SSELECT FILE FIRST 2? Thanks, Nick Cipollina -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, May 25, 2006 9:03 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] OK...Is there a wayUV ED DICT FILE REC.COUNT 001 I 002 @RECCOUNT 003 004 Cnt 005 5R 006 S SORT FILE WITH REC.COUNT 2 N'es pas? __ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Gallen [EMAIL PROTECTED] Sent: Friday, 26 May 2006 05:16 To: u2-users@listserver.u2ug.org Subject: [U2] OK...Is there a wayUV I want to sort a file by @ID and only take the first two items... SELECT FILE BY @ID SAMPLE 2 doesn't work, it first takes the sample of 2, then sorts it. SELECT FILE BY @ID SELECT FILE SAMPLE 2 works, but takes two lines How can I phrase my SELECT so it will sort first, then sample later, instead of sample first, sort later? I'm running UV. George George Gallen Senior Programmer/Analyst Accounting/Data Division [EMAIL PROTECTED] ph:856.848.1000 Ext 220 SLACK Incorporated - Delivering the best in health care information and education worldwide. http://www.slackinc.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- 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/
RE: [U2] OK...Is there a way....UV
NOPE. Same thing. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Nick Cipollina Sent: Friday, May 26, 2006 8:25 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] OK...Is there a wayUV What about SSELECT FILE FIRST 2? Thanks, Nick Cipollina -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, May 25, 2006 9:03 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] OK...Is there a wayUV ED DICT FILE REC.COUNT 001 I 002 @RECCOUNT 003 004 Cnt 005 5R 006 S SORT FILE WITH REC.COUNT 2 N'es pas? __ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Gallen [EMAIL PROTECTED] Sent: Friday, 26 May 2006 05:16 To: u2-users@listserver.u2ug.org Subject: [U2] OK...Is there a wayUV I want to sort a file by @ID and only take the first two items... SELECT FILE BY @ID SAMPLE 2 doesn't work, it first takes the sample of 2, then sorts it. SELECT FILE BY @ID SELECT FILE SAMPLE 2 works, but takes two lines How can I phrase my SELECT so it will sort first, then sample later, instead of sample first, sort later? I'm running UV. George George Gallen Senior Programmer/Analyst Accounting/Data Division [EMAIL PROTECTED] ph:856.848.1000 Ext 220 SLACK Incorporated - Delivering the best in health care information and education worldwide. http://www.slackinc.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] OK...Is there a way....UV
Two selects can be faster than one...so, there's no need to worry about the number of selects. The Unidata optimization routines for multiple indexes are not always as fast a manually tuned, multiple selects... -Original Message- From: Vance, Kathy [mailto:[EMAIL PROTECTED] Sent: Friday, May 26, 2006 8:20 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] OK...Is there a wayUV It is true that the sample is the first execution before the sorting takes place. Oracle DB dose the same thing. I was unsuccessfully trying to use sub-query in this case. Kathy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward Sent: Thursday, May 25, 2006 6:36 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] OK...Is there a wayUV Played around a bit and figured out that SSELECT adds BY @ID to the end of the select attributes, hence SSELECT FILE BY @ID is redundant. SSELECT FILE BY F2 is equivalent to SELECT FILE BY F2 BY @ID. In any case, it appears that SAMPLE has a higher execution priority in R/LIST processing, thereby forcing multiple lines in George's paragraph. Sorry George. BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brad Davis Sent: Thursday, May 25, 2006 2:40 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] OK...Is there a wayUV Use two statements: 1SSELECT FILE BY @ID 2SELECT FILE SAMPLE 2 Or 1SELECT FILE SAMPLE 2 2SSELECT FILE BY @ID -Original Message- From: Bob Woodward [mailto:[EMAIL PROTECTED] Sent: Thursday, May 25, 2006 4:11 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] OK...Is there a wayUV Have you tried: SORT FILE SAMPLE 2 BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Gallen Sent: Thursday, May 25, 2006 12:16 PM To: u2-users@listserver.u2ug.org Subject: [U2] OK...Is there a wayUV I want to sort a file by @ID and only take the first two items... SELECT FILE BY @ID SAMPLE 2 doesn't work, it first takes the sample of 2, then sorts it. SELECT FILE BY @ID SELECT FILE SAMPLE 2 works, but takes two lines How can I phrase my SELECT so it will sort first, then sample later, instead of sample first, sort later? I'm running UV. George George Gallen Senior Programmer/Analyst Accounting/Data Division [EMAIL PROTECTED] ph:856.848.1000 Ext 220 SLACK Incorporated - Delivering the best in health care information and education worldwide. http://www.slackinc.com --- 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/ --- 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/ --- 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/
RE: [U2] OK...Is there a way....UV
George Hmmm, how are your IDs ordered? Just wondering whether something along these lines might work... SELECT ID TO SLIST 0 FROM YourFile WHERE ID = (SELECT MIN(ID)+1 FROM YourFile) ORDER BY ID; Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Gallen Sent: 25 May 2006 20:16 To: u2-users@listserver.u2ug.org Subject: [U2] OK...Is there a wayUV I want to sort a file by @ID and only take the first two items... --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] OK...Is there a way....UV
hmm. there's a new one. Yes, that did work. Thanks George -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Thursday, May 25, 2006 9:03 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] OK...Is there a wayUV ED DICT FILE REC.COUNT 001 I 002 @RECCOUNT 003 004 Cnt 005 5R 006 S SORT FILE WITH REC.COUNT 2 N'es pas? __ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Gallen [EMAIL PROTECTED] Sent: Friday, 26 May 2006 05:16 To: u2-users@listserver.u2ug.org Subject: [U2] OK...Is there a wayUV I want to sort a file by @ID and only take the first two items... SELECT FILE BY @ID SAMPLE 2 doesn't work, it first takes the sample of 2, then sorts it. SELECT FILE BY @ID SELECT FILE SAMPLE 2 works, but takes two lines How can I phrase my SELECT so it will sort first, then sample later, instead of sample first, sort later? I'm running UV. George George Gallen Senior Programmer/Analyst Accounting/Data Division [EMAIL PROTECTED] ph:856.848.1000 Ext 220 SLACK Incorporated - Delivering the best in health care information and education worldwide. http://www.slackinc.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- 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/
RE: [U2] OK...Is there a way....UV
I wondered when SQL would come into this:) Only problem is that the filename has -'s in it, but I suppose I could always make a Q pointer. I'll have to try that later. Thanks George -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Brian Leach Sent: Friday, May 26, 2006 9:48 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] OK...Is there a wayUV George Hmmm, how are your IDs ordered? Just wondering whether something along these lines might work... SELECT ID TO SLIST 0 FROM YourFile WHERE ID = (SELECT MIN(ID)+1 FROM YourFile) ORDER BY ID; Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Gallen Sent: 25 May 2006 20:16 To: u2-users@listserver.u2ug.org Subject: [U2] OK...Is there a wayUV I want to sort a file by @ID and only take the first two items... --- 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/
RE: [U2] OK...Is there a way....UV
HMM. No. Now it's not working, It returns all ID's. I must have done something wrong. Seems it doesn't like to be used in the selecting stage, but will be happy to be used in the display stage. SSELECT file WITH RCNT 3 RCNT is setup as below except I didn't call it REC.COUNT -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of George Gallen Sent: Friday, May 26, 2006 10:18 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] OK...Is there a wayUV hmm. there's a new one. Yes, that did work. Thanks George -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Thursday, May 25, 2006 9:03 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] OK...Is there a wayUV ED DICT FILE REC.COUNT 001 I 002 @RECCOUNT 003 004 Cnt 005 5R 006 S SORT FILE WITH REC.COUNT 2 N'es pas? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] OK...Is there a way....UV
Also the same bad results when I tried either old Pick style methods NI.CNTR9998.CNTR 001 A A 002 0 9998 008 ANI+'0' 009 R R 010 8 8 Rog George Gallen wrote: HMM. No. Now it's not working, It returns all ID's. I must have done something wrong. Seems it doesn't like to be used in the selecting stage, but will be happy to be used in the display stage. SSELECT file WITH RCNT 3 RCNT is setup as below except I didn't call it REC.COUNT -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of George Gallen Sent: Friday, May 26, 2006 10:18 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] OK...Is there a wayUV hmm. there's a new one. Yes, that did work. Thanks George -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Thursday, May 25, 2006 9:03 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] OK...Is there a wayUV ED DICT FILE REC.COUNT 001 I 002 @RECCOUNT 003 004 Cnt 005 5R 006 S SORT FILE WITH REC.COUNT 2 N'es pas? --- 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/
RE: [U2] OK...Is there a way....UV
Have you tried: SORT FILE SAMPLE 2 BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Gallen Sent: Thursday, May 25, 2006 12:16 PM To: u2-users@listserver.u2ug.org Subject: [U2] OK...Is there a wayUV I want to sort a file by @ID and only take the first two items... SELECT FILE BY @ID SAMPLE 2 doesn't work, it first takes the sample of 2, then sorts it. SELECT FILE BY @ID SELECT FILE SAMPLE 2 works, but takes two lines How can I phrase my SELECT so it will sort first, then sample later, instead of sample first, sort later? I'm running UV. George George Gallen Senior Programmer/Analyst Accounting/Data Division [EMAIL PROTECTED] ph:856.848.1000 Ext 220 SLACK Incorporated - Delivering the best in health care information and education worldwide. http://www.slackinc.com --- 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/
RE: [U2] OK...Is there a way....UV
Oops. You want a SELECT... Try SSELECT FILE SAMPLE 2. BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Gallen Sent: Thursday, May 25, 2006 12:16 PM To: u2-users@listserver.u2ug.org Subject: [U2] OK...Is there a wayUV I want to sort a file by @ID and only take the first two items... SELECT FILE BY @ID SAMPLE 2 doesn't work, it first takes the sample of 2, then sorts it. SELECT FILE BY @ID SELECT FILE SAMPLE 2 works, but takes two lines How can I phrase my SELECT so it will sort first, then sample later, instead of sample first, sort later? I'm running UV. George George Gallen Senior Programmer/Analyst Accounting/Data Division [EMAIL PROTECTED] ph:856.848.1000 Ext 220 SLACK Incorporated - Delivering the best in health care information and education worldwide. http://www.slackinc.com --- 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/
RE: [U2] OK...Is there a way....UV
the BY forces a SSELECT, but I did try it as well, same result. Executing the two statements isn't a big deal, just wondering if there is a way to reverse the order of the sample and the sort. Sounds like a Harry Potter book, the Order of the Sample and the Sort? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Bob Woodward Sent: Thursday, May 25, 2006 4:13 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] OK...Is there a wayUV Oops. You want a SELECT... Try SSELECT FILE SAMPLE 2. BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Gallen Sent: Thursday, May 25, 2006 12:16 PM To: u2-users@listserver.u2ug.org Subject: [U2] OK...Is there a wayUV I want to sort a file by @ID and only take the first two items... SELECT FILE BY @ID SAMPLE 2 doesn't work, it first takes the sample of 2, then sorts it. SELECT FILE BY @ID SELECT FILE SAMPLE 2 works, but takes two lines How can I phrase my SELECT so it will sort first, then sample later, instead of sample first, sort later? I'm running UV. George George Gallen Senior Programmer/Analyst Accounting/Data Division [EMAIL PROTECTED] ph:856.848.1000 Ext 220 SLACK Incorporated - Delivering the best in health care information and education worldwide. http://www.slackinc.com --- 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] OK...Is there a way....UV
If you have an index on the file the index is already sorted so all you have to do is use the index when you select. The only criteria would be that the index is on the key or a field that will include all of the records or NO.NULLS is off. Example: SELECT CUST.MSTR BY CLIENT.6 SAMPLE 2 Will give you the first two sorted entries. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Gallen Sent: Thursday, May 25, 2006 2:16 PM To: u2-users@listserver.u2ug.org Subject: [U2] OK...Is there a wayUV I want to sort a file by @ID and only take the first two items... SELECT FILE BY @ID SAMPLE 2 doesn't work, it first takes the sample of 2, then sorts it. SELECT FILE BY @ID SELECT FILE SAMPLE 2 works, but takes two lines How can I phrase my SELECT so it will sort first, then sample later, instead of sample first, sort later? I'm running UV. George George Gallen Senior Programmer/Analyst Accounting/Data Division [EMAIL PROTECTED] ph:856.848.1000 Ext 220 SLACK Incorporated - Delivering the best in health care information and education worldwide. http://www.slackinc.com --- 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/
RE: [U2] OK...Is there a way....UV
I have found that U2 works the fastest in UniBasic via clearselect ALL execute SELECT FILE BY @ID loop... read R.Item from F.FILE, This.Item This.Item = R.Item23 begin case case This.Item = My.Item ; null case 1; go Next.Item end case My.Array-1 = This.Sample Next.Item: next --Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of George Gallen Sent: Thursday, May 25, 2006 3:16 PM To: u2-users@listserver.u2ug.org Subject: [U2] OK...Is there a wayUV I want to sort a file by @ID and only take the first two items... SELECT FILE BY @ID SAMPLE 2 doesn't work, it first takes the sample of 2, then sorts it. SELECT FILE BY @ID SELECT FILE SAMPLE 2 works, but takes two lines How can I phrase my SELECT so it will sort first, then sample later, instead of sample first, sort later? I'm running UV. George George Gallen Senior Programmer/Analyst Accounting/Data Division [EMAIL PROTECTED] ph:856.848.1000 Ext 220 SLACK Incorporated - Delivering the best in health care information and education worldwide. http://www.slackinc.com --- 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/
RE: [U2] OK...Is there a way....UV
ok. but I would be using this from TCL, a paragraph. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Brutzman, Bill Sent: Thursday, May 25, 2006 5:17 PM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] OK...Is there a wayUV I have found that U2 works the fastest in UniBasic via clearselect ALL execute SELECT FILE BY @ID loop... read R.Item from F.FILE, This.Item This.Item = R.Item23 begin case case This.Item = My.Item ; null case 1; go Next.Item end case My.Array-1 = This.Sample Next.Item: next --Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of George Gallen Sent: Thursday, May 25, 2006 3:16 PM To: u2-users@listserver.u2ug.org Subject: [U2] OK...Is there a wayUV I want to sort a file by @ID and only take the first two items... SELECT FILE BY @ID SAMPLE 2 doesn't work, it first takes the sample of 2, then sorts it. SELECT FILE BY @ID SELECT FILE SAMPLE 2 works, but takes two lines How can I phrase my SELECT so it will sort first, then sample later, instead of sample first, sort later? I'm running UV. George George Gallen Senior Programmer/Analyst Accounting/Data Division [EMAIL PROTECTED] ph:856.848.1000 Ext 220 SLACK Incorporated - Delivering the best in health care information and education worldwide. http://www.slackinc.com --- 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] OK...Is there a way....UV
Use two statements: 1SSELECT FILE BY @ID 2SELECT FILE SAMPLE 2 Or 1SELECT FILE SAMPLE 2 2SSELECT FILE BY @ID -Original Message- From: Bob Woodward [mailto:[EMAIL PROTECTED] Sent: Thursday, May 25, 2006 4:11 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] OK...Is there a wayUV Have you tried: SORT FILE SAMPLE 2 BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Gallen Sent: Thursday, May 25, 2006 12:16 PM To: u2-users@listserver.u2ug.org Subject: [U2] OK...Is there a wayUV I want to sort a file by @ID and only take the first two items... SELECT FILE BY @ID SAMPLE 2 doesn't work, it first takes the sample of 2, then sorts it. SELECT FILE BY @ID SELECT FILE SAMPLE 2 works, but takes two lines How can I phrase my SELECT so it will sort first, then sample later, instead of sample first, sort later? I'm running UV. George George Gallen Senior Programmer/Analyst Accounting/Data Division [EMAIL PROTECTED] ph:856.848.1000 Ext 220 SLACK Incorporated - Delivering the best in health care information and education worldwide. http://www.slackinc.com --- 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] OK...Is there a way....UV
Try SSELECT fname Sample 2 -Original Message- From: George Gallen [SMTP:[EMAIL PROTECTED] Sent: Thursday, May 25, 2006 2:19 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] OK...Is there a wayUV ok. but I would be using this from TCL, a paragraph. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Brutzman, Bill Sent: Thursday, May 25, 2006 5:17 PM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] OK...Is there a wayUV I have found that U2 works the fastest in UniBasic via clearselect ALL execute SELECT FILE BY @ID loop... read R.Item from F.FILE, This.Item This.Item = R.Item23 begin case case This.Item = My.Item ; null case 1; go Next.Item end case My.Array-1 = This.Sample Next.Item: next --Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of George Gallen Sent: Thursday, May 25, 2006 3:16 PM To: u2-users@listserver.u2ug.org Subject: [U2] OK...Is there a wayUV I want to sort a file by @ID and only take the first two items... SELECT FILE BY @ID SAMPLE 2 doesn't work, it first takes the sample of 2, then sorts it. SELECT FILE BY @ID SELECT FILE SAMPLE 2 works, but takes two lines How can I phrase my SELECT so it will sort first, then sample later, instead of sample first, sort later? I'm running UV. George George Gallen Senior Programmer/Analyst Accounting/Data Division [EMAIL PROTECTED] ph:856.848.1000 Ext 220 SLACK Incorporated - Delivering the best in health care information and education worldwide. http://www.slackinc.com --- 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/ --- 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/
RE: [U2] OK...Is there a way....UV
Played around a bit and figured out that SSELECT adds BY @ID to the end of the select attributes, hence SSELECT FILE BY @ID is redundant. SSELECT FILE BY F2 is equivalent to SELECT FILE BY F2 BY @ID. In any case, it appears that SAMPLE has a higher execution priority in R/LIST processing, thereby forcing multiple lines in George's paragraph. Sorry George. BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brad Davis Sent: Thursday, May 25, 2006 2:40 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] OK...Is there a wayUV Use two statements: 1SSELECT FILE BY @ID 2SELECT FILE SAMPLE 2 Or 1SELECT FILE SAMPLE 2 2SSELECT FILE BY @ID -Original Message- From: Bob Woodward [mailto:[EMAIL PROTECTED] Sent: Thursday, May 25, 2006 4:11 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] OK...Is there a wayUV Have you tried: SORT FILE SAMPLE 2 BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Gallen Sent: Thursday, May 25, 2006 12:16 PM To: u2-users@listserver.u2ug.org Subject: [U2] OK...Is there a wayUV I want to sort a file by @ID and only take the first two items... SELECT FILE BY @ID SAMPLE 2 doesn't work, it first takes the sample of 2, then sorts it. SELECT FILE BY @ID SELECT FILE SAMPLE 2 works, but takes two lines How can I phrase my SELECT so it will sort first, then sample later, instead of sample first, sort later? I'm running UV. George George Gallen Senior Programmer/Analyst Accounting/Data Division [EMAIL PROTECTED] ph:856.848.1000 Ext 220 SLACK Incorporated - Delivering the best in health care information and education worldwide. http://www.slackinc.com --- 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/ --- 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/
RE: [U2] OK...Is there a way....UV
ED DICT FILE REC.COUNT 001 I 002 @RECCOUNT 003 004 Cnt 005 5R 006 S SORT FILE WITH REC.COUNT 2 N'es pas? __ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Gallen [EMAIL PROTECTED] Sent: Friday, 26 May 2006 05:16 To: u2-users@listserver.u2ug.org Subject: [U2] OK...Is there a wayUV I want to sort a file by @ID and only take the first two items... SELECT FILE BY @ID SAMPLE 2 doesn't work, it first takes the sample of 2, then sorts it. SELECT FILE BY @ID SELECT FILE SAMPLE 2 works, but takes two lines How can I phrase my SELECT so it will sort first, then sample later, instead of sample first, sort later? I'm running UV. George George Gallen Senior Programmer/Analyst Accounting/Data Division [EMAIL PROTECTED] ph:856.848.1000 Ext 220 SLACK Incorporated - Delivering the best in health care information and education worldwide. http://www.slackinc.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
