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