Re: problem with select count(distinct

Clive Eisen wrote: > scottishpoet wrote: > >>if you need bugs fixed then you need a maintenance contract and the >>official veriosn of the product from IBM > > No shit - I'd never have guessed. > > >>if you are member of partnerworld and have elected to purchase the >>value package (I believe its around $2000) you have access to all IBM >>PA products for your own internal use and you are entitled to >>electronic support through PA for those products! Once a fix for this >>problem is made generally available (UC6) it will appear on the >>partnerwolrd site immediately. > > > As my post made abundantly clear this is the download from IIUG > > I'm doing a proof of concept and trying to hide the bug from my > potential client who would be paying for IDS. > > What would you suggest I do? 1) Add '{+ AVOID_INDEX (mytable bad_index_name) } to the query. 2) Ask IBM for an unlimited evaluation copy of IDS 10.00.xC5W5 or later. You've got to fill out some paper work and promise to destroy the server once the eval period is over, but that should get you through your POC. Informix used to be quite lenient - allowing the customer to define the length of the eval as long as it wasn't outrageous and you could make a case for a 6 month eval for example. Art S. Kagel