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

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 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 
> environment. Can you please suggest if the issue is with DB engine or 
> Informix driver in Perl?
>
> Thanks,
>
> Ram
>