Re: Out of memory while reading tuples error

Hi Barry,

sorry for the late reply.

(2014/06/20 0:14), Barry Bell wrote:
> Hi:
> When executing a SQL statement with a large # of records (500,000 in this case),
> I am getting " Out of memory while reading tuples error"
> Communication error while getting a tuple;
> Error fetching next row
>
> I turned on USEDECLAREFETCH=1 (B6=1), which has no effect on this error.
>
> Any Ideas?

Could you tell us the operations you are doing?

regards,
Hiroshi Inoue

> Barry Bell
> Senior Developer/Analyst
> Logistics
> Harte Hanks
> 1525 NW 3rd ST
> Deerfield Beach FL, 33442
> 954-429-3771 Ext 267 office
> 954-281-1464 fax
>
> hartehanks.com / linkedin / twitter / facebook

--
I am using the free version of SPAMfighter.
SPAMfighter has removed 11063 of my spam emails to date.
Get the free SPAMfighter here: http://www.spamfighter.com/len

Do you have a slow PC? Try a Free scan
http://www.spamfighter.com/SLOW-PCfighter?cid=sigen