Re: Error -9067 and ACE

>From: chayase@aol.com (CHAYASE) >Date: 17 Jul 1997 03:57:44 GMT >X-Informix-List-Id: <news.40525> > >I work for a library system in NY and tried to output patron records to a >file. Since these records were supposed to go to another vendor for >processing the data retrieved had to be in a very specific format. Each >row needed 35 data elements, most involving quotation marks (I used ascii >34 to create ")around the data to indicate it was a char type. > >I wrote the ACE script in steps and tested the script after each >modification. When I tried to retrieve few more elements I got the -9067 >error indicating the expression was too complicated. > >We are running Informix 4.12. Could this error be a limitation of the >version we're running? Could my script be too verbose? The script is >actually very simple but I'm asking for a lot of data to be put on just >one line. finderr -9067 sayeth (when reformatted slightly): -9067 ACE's arithmetic stack has exceeded its bounds. The expression here is too complicated. Reduce the complexity of the arithmetic expression. For example, divide the expression into subexpressions, and assign the values of each to a variable. Most probably you can work around your problem by changing your current single PRINT statement into a sequence of smaller ones, all except the last of which should be terminated by a ';' to suppress the newline at the end of the PRINT command. I don't think the limits on the ACE expression stack have been changed in living memory. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> PS: Warning I do not reply to messages with anti-spam in the return path.