SQL: -208: Memory allocation failed during query processing

2013-07-02 Thread KOTAGIRI, RAMPRASAD
Environment: Perl v5.8.4 built for sun4-solaris-64int [SunOS 5.10] Perl DBI uses Informix DBD, DBI connect and prepare statement are successful, execute routine returns error: SQL: -208: Memory allocation failed during query processing The same SQL query works fine and returns results in other

Re: SQL: -208: Memory allocation failed during query processing

2013-07-02 Thread Andrew Snyder
are you reading all of the rows at once? It is possible that the results set is too large to fit into memory- get a count of the number of rows that would be returned to eliminated that as a possibility. On 07/01/2013 06:20 PM, KOTAGIRI, RAMPRASAD wrote: Environment: Perl v5.8.4 built

Re: SQL: -208: Memory allocation failed during query processing

2013-07-02 Thread Jonathan Leffler
AFAICR, the DBD::Informix driver does not report error -208 when client-side memory allocation fails in DBD::Informix code, so the problem is almost certainly in the server, not in Perl, DBI or DBD::Informix. It might conceivably be in the ESQL/C code. You say it works in another environment;