[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
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
[U2] Building XML using the UV XDOM API functions
I have recently been involved in a project that gave me my first chance to get acquainted with the UV XDOM API functions. gripe I must say that I was bitterly disappointed with the documentation on the XML functionality in UniVerse 10.2. Nothing more than a simple description of each of the API functions, and no clear example of how to go about getting started. Not to mention the inter-weaving of UniData and UniVerse configurations that lead me into much confusion about what was going on. /gripe Once I got a handle on how things worked, it was obvious that if we were to be building XML docs in code, we would need to create some supporting code to make things easier. I ended up creating a function to add new elements and attributes that made a huge difference. I used a function instead of a subroutine because it fits in easier with the XDOM API function calls, and this makes it easier to adopt. I created a description of the function and its implementation over at http://gdoesu2.wordpress.com/2010/10/25/an-easier-way-to-build-xml-in-universe/, in case anyone else needs a helping hand getting started with manual XML document building. The site also has a few other entries on the quirks/features of the XDOM API functions which might be of interest as well. Regards, Gregor This email and any attachments to it are confidential. You must not use, disclose or act on the email if you are not the intended recipient. Liability limited by a scheme approved under Professional Standards Legislation. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Building XML using the UV XDOM API functions
Gregor, your comments serve as a testimonial to support my position against using many of these vendor-supplied toolkits. Some of them are OK, but many not. People insist on the DBMS vendors building stuff for them, but then we get the mess that you've described. For this reason I continue to recommend at least consideration for integration with tools that are outside of the DBMS. DBMS vendors should be focusing on making superior databases, not XML, web services, or a lot of this other fluff. People in the open source and commercial markets spend a great deal of time focused on these things, and because of this, their offerings are often much better. So take a look around and weigh other offerings against the built-in functionality. It would be nice to see people here comparing more toolkits - it might save others from feeling like they're stuck with whatever is provided by the DBMS vendors. T ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users