Re: [U2] too many values in sort
You can try saving your list of keys you want to sort and use Unix's sort program on that savedlist. Use the port number on your saved list to make sure it is unique. - Original Message From: Kevin King precisonl...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Mon, October 25, 2010 11:54:25 AM Subject: [U2] too many values in sort Unidata 6.1.15 on AIX. The following command: SSELECT SHOPPING.LIST BY.EXP PROD.NUM Yields the message too many values in sort. There is one record in this file with 36,457 product numbers but would that break the BY.EXP? If so, is there a config parameter somewhere that could be tweaked to make this work? -Kevin http://www.PrecisOnline.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
Re: [U2] too many values in sort
AFAIK SSELECT BY.EXP returns a select list with the record ID and the position in the multivalued attribute. At least on ADDS Mentor it did. I didn't use it for decades because I haven't had any need for such a list, and I haven't tried it on UD yet. So I don't think anything short of a Basic program will be able to solve your problem if there is a restriction on number of values in any one record. Try some smaller records, save the list and have a look at the data. Then you could run a program to generate the same array and write it to the SAVEDLIST file. Ugly but it might actually do the job. Mecki On 26/10/2010 12:22, Jacques G. wrote: You can try saving your list of keys you want to sort and use Unix's sort program on that savedlist. Use the port number on your saved list to make sure it is unique. - Original Message From: Kevin King precisonl...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Mon, October 25, 2010 11:54:25 AM Subject: [U2] too many values in sort Unidata 6.1.15 on AIX. The following command: SSELECT SHOPPING.LIST BY.EXP PROD.NUM Yields the message too many values in sort. There is one record in this file with 36,457 product numbers but would that break the BY.EXP? If so, is there a config parameter somewhere that could be tweaked to make this work? -Kevin http://www.PrecisOnline.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] too many values in sort
On our UniData 6.1 system: :LIMIT ... U_MAXBYEXPVAL: Number of values BY.EXP can handle = 10240. ... According to HELP LIMIT: The ECL LIMIT command displays maximum size limits for elements of UniData. These limits are NOT CONFIGURABLE. Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Monday, October 25, 2010 7:54 AM To: U2 Users List Subject: [U2] too many values in sort Unidata 6.1.15 on AIX. The following command: SSELECT SHOPPING.LIST BY.EXP PROD.NUM Yields the message too many values in sort. There is one record in this file with 36,457 product numbers but would that break the BY.EXP? If so, is there a config parameter somewhere that could be tweaked to make this work? -Kevin http://www.PrecisOnline.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
Re: [U2] too many values in sort
Agreed on all points. Will check this on my customer's system. On Mon, Oct 25, 2010 at 9:11 AM, Dave Davis dda...@harriscomputer.comwrote: That's some shopping list. I haven't seen anything anywhere that lets you adjust this limit. Besides breaking the record up into separate tables, you may need to make a temp file that normalizes this for you, by doing something like stringing the value or row number into the key. I've never had anything approaching 10240 values in a multivalue. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Monday, October 25, 2010 10:54 AM To: U2 Users List Subject: [U2] too many values in sort Unidata 6.1.15 on AIX. The following command: SSELECT SHOPPING.LIST BY.EXP PROD.NUM Yields the message too many values in sort. There is one record in this file with 36,457 product numbers but would that break the BY.EXP? If so, is there a config parameter somewhere that could be tweaked to make this work? -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users html body Dave Davis Team Lead, Ramp;D P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [ http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [ http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif] 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. /body /html ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] too many values in sort
Of course, why would anyone need a BASIC program larger than 32K? I believe it's called progress. Non-configurable size limits are just __NOT__ acceptable in today's computing environment. The attendant work-arounds are just plain ugly, and inexcusable. The greatest aspect of PICK is the narrow gulf between the logical and the physical; database structure is logical, query syntax is logical, in fact, the entire machine is a logical machine. Twenty year old physical limitation should have been resolved at least ten years ago. :-( Bill Kevin King said the following on 10/25/2010 8:27 AM: Agreed on all points. Will check this on my customer's system. On Mon, Oct 25, 2010 at 9:11 AM, Dave Davisdda...@harriscomputer.comwrote: That's some shopping list. I haven't seen anything anywhere that lets you adjust this limit. Besides breaking the record up into separate tables, you may need to make a temp file that normalizes this for you, by doing something like stringing the value or row number into the key. I've never had anything approaching 10240 values in a multivalue. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Monday, October 25, 2010 10:54 AM To: U2 Users List Subject: [U2] too many values in sort Unidata 6.1.15 on AIX. The following command: SSELECT SHOPPING.LIST BY.EXP PROD.NUM Yields the message too many values in sort. There is one record in this file with 36,457 product numbers but would that break the BY.EXP? If so, is there a config parameter somewhere that could be tweaked to make this work? -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] too many values in sort
Aging standards aside, I'd REALLY be questioning the design of a function that uses multi-values approaching that number of items.I would think it can't be very efficient... Mike R. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Monday, October 25, 2010 12:52 PM To: U2 Users List Subject: Re: [U2] too many values in sort Of course, why would anyone need a BASIC program larger than 32K? I believe it's called progress. Non-configurable size limits are just __NOT__ acceptable in today's computing environment. The attendant work-arounds are just plain ugly, and inexcusable. The greatest aspect of PICK is the narrow gulf between the logical and the physical; database structure is logical, query syntax is logical, in fact, the entire machine is a logical machine. Twenty year old physical limitation should have been resolved at least ten years ago. :-( Bill Kevin King said the following on 10/25/2010 8:27 AM: Agreed on all points. Will check this on my customer's system. On Mon, Oct 25, 2010 at 9:11 AM, Dave Davisdda...@harriscomputer.comwrote: That's some shopping list. I haven't seen anything anywhere that lets you adjust this limit. Besides breaking the record up into separate tables, you may need to make a temp file that normalizes this for you, by doing something like stringing the value or row number into the key. I've never had anything approaching 10240 values in a multivalue. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Monday, October 25, 2010 10:54 AM To: U2 Users List Subject: [U2] too many values in sort Unidata 6.1.15 on AIX. The following command: SSELECT SHOPPING.LIST BY.EXP PROD.NUM Yields the message too many values in sort. There is one record in this file with 36,457 product numbers but would that break the BY.EXP? If so, is there a config parameter somewhere that could be tweaked to make this work? -Kevin http://www.PrecisOnline.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
Re: [U2] too many values in sort
Mike: You may be right, and I'd mostly think so too. However, now that I spend most of my time in the web, I've often been wrong and am not prescient enough to foresee everything. Data loads and unexpected requirements often take me by surprise and I'd like to think that Pick-like systems operate on the virtual memory model where limits are simply passed to disk and slow things down, not abort them. ...if you know what I mean.. Bill Mike Randall said the following on 10/25/2010 10:51 AM: Aging standards aside, I'd REALLY be questioning the design of a function that uses multi-values approaching that number of items.I would think it can't be very efficient... Mike R. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Monday, October 25, 2010 12:52 PM To: U2 Users List Subject: Re: [U2] too many values in sort Of course, why would anyone need a BASIC program larger than 32K? I believe it's called progress. Non-configurable size limits are just __NOT__ acceptable in today's computing environment. The attendant work-arounds are just plain ugly, and inexcusable. The greatest aspect of PICK is the narrow gulf between the logical and the physical; database structure is logical, query syntax is logical, in fact, the entire machine is a logical machine. Twenty year old physical limitations should have been resolved at least ten years ago. :-( Bill Kevin King said the following on 10/25/2010 8:27 AM: Agreed on all points. Will check this on my customer's system. On Mon, Oct 25, 2010 at 9:11 AM, Dave Davisdda...@harriscomputer.comwrote That's some shopping list. I haven't seen anything anywhere that lets you adjust this limit. Besides breaking the record up into separate tables, you may need to make a temp file that normalizes this for you, by doing something like stringing the value or row number into the key. I've never had anything approaching 10240 values in a multivalue. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Monday, October 25, 2010 10:54 AM To: U2 Users List Subject: [U2] too many values in sort Unidata 6.1.15 on AIX. The following command: SSELECT SHOPPING.LIST BY.EXP PROD.NUM Yields the message too many values in sort. There is one record in this file with 36,457 product numbers but would that break the BY.EXP? If so, is there a config parameter somewhere that could be tweaked to make this work? -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] too many values in sort
I don't think UniVerse has the same limits (SELBUF controls in memory size) but then UniVerse doesn't use the same structure as Unidata in their selects. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Monday, October 25, 2010 11:52 AM To: U2 Users List Subject: Re: [U2] too many values in sort Of course, why would anyone need a BASIC program larger than 32K? I believe it's called progress. Non-configurable size limits are just __NOT__ acceptable in today's computing environment. The attendant work-arounds are just plain ugly, and inexcusable. The greatest aspect of PICK is the narrow gulf between the logical and the physical; database structure is logical, query syntax is logical, in fact, the entire machine is a logical machine. Twenty year old physical limitation should have been resolved at least ten years ago. :-( Bill Kevin King said the following on 10/25/2010 8:27 AM: Agreed on all points. Will check this on my customer's system. On Mon, Oct 25, 2010 at 9:11 AM, Dave Davisdda...@harriscomputer.comwrote: That's some shopping list. I haven't seen anything anywhere that lets you adjust this limit. Besides breaking the record up into separate tables, you may need to make a temp file that normalizes this for you, by doing something like stringing the value or row number into the key. I've never had anything approaching 10240 values in a multivalue. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Monday, October 25, 2010 10:54 AM To: U2 Users List Subject: [U2] too many values in sort Unidata 6.1.15 on AIX. The following command: SSELECT SHOPPING.LIST BY.EXP PROD.NUM Yields the message too many values in sort. There is one record in this file with 36,457 product numbers but would that break the BY.EXP? If so, is there a config parameter somewhere that could be tweaked to make this work? -Kevin http://www.PrecisOnline.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
Re: [U2] too many values in sort
Mike, I agree with you. This is unfortunately a vendor application and they're storing quick retrieval lists of products. The customer can build these lists (via Excel import) as big as they want. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] too many values in sort
If I were stuck with such a limitation, my approach might be to try an replace that function with an 'outside the application' index or something. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Monday, October 25, 2010 4:22 PM To: U2 Users List Subject: Re: [U2] too many values in sort Mike, I agree with you. This is unfortunately a vendor application and they're storing quick retrieval lists of products. The customer can build these lists (via Excel import) as big as they want. ___ 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
