Re: more on ace

In article <1p00kdINNc04@emory.mathcs.emory.edu> ellen@hpbs2571.boi.hp.com (Ellen K. Osinski) writes: >The first, when doing saceprep on an ace report with 33 select statements >(we run some intense reports), I consistently got a -8018 >gramatical error pointing to a completely illogical line. >... >Is 30 select statements some magic number? >...thus I had 29 select statements and suddenly the >expected data existed in the output file. > >Is 29 select statements some other magic number?? > >We are running on HP9000/750 ISQL 4.10.UD2 HPUX 8.07 Call Informix tech support and ask for the status of bug # 15223. This says that having more than 29 SELECT...INTO TEMP statements in an ace report causes error -8018 in saceprep. Since all SELECTs but the last have to have INTO TEMP, this would appear to cover both your 29 and 30 numbers. The problem is reported against 4.10, and I didn't see a fix release scheduled, but T.S. understands these reports better than I do. Dave Cortesi