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.com>wrote:
> 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, R&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