Re: Informix size limit on sql query through ODBC, ASP?

Posted in 2003

nate — 4 Jun 2003 14:23:07 -0700 — source: Usenet: comp.databases.informix

Jonathan Leffler <jleffler@earthlink.net> wrote in message news:<3EDD7432.6040506@earthlink.net>... > nate wrote: > > Can anyone tell me if there is a size limit on a sql statement sent to > > Informix via ODBC? > > In general, the limit is 64 KB (eg in ESQL/C). I don't know whether > ODBC has a smaller limit, but it shouldn't. > > > How can I change this value on the fly (such as in > > an ASP page) or do I have to set the value in Informix? > > > It is not a configurable parameter - again, in ESQL/C et al. If the limit is 64 KB, then I can't figure out why I am getting the error (I never posted the actuall asp error, so here it is)... Microsoft JScript runtime error '800a01fb' An exception occured ...The sql statement is only 16,599 characters long when I get the error for a date range of 02/01/03 - 02/28/03. But the sql statement is almost the same at 16,007 characters long when I run the report for a date range of 02/01/03 - 02/27/03, and I do not get the error? Could it be because my sql statement has 28 select...union clauses? What else could it be?