Re: can't initialize sort area

[ Query about how to fix Informix error -566, "can't initialize sort area", or some such ] > Only suggestion I have is to index the tables in such a way that > sorting is not needed if that is possible. ... If you can't change > your indexing strategy to make this work, I would think about an > intermediate temp table and two or three selects instead of the > monster select. Those are the very advice that I gave my colleague when he asked me that question. Sure enough we can workaround the problem but I guess we are more interested in knowing "which resource is not enough" than anything else <devilish grin>. Sorry about not revealing our real intentions in the last posting. Thanks for your reply all the same.