Re: Error -9067 and ACE

chayase@aol.com (CHAYASE) wrote: :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. May be you could split the print line in two or more using a semicolon on the first line(s) to avoide a newline. I don't remember ACE too well any more, but believe it has this functionality. : :Thanks for listening. : :Colleen :chayase@aol.com Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org