error inserting/updating

[sourceuno]

I'm trying to merge several tables into 1 large table. The several small tables may have records that exist in other small tables, so I perform a check in the large table to see if the record exists. If it does it exist, I perform an update. If not, then I insert it. The inserts/updates work fine up to a certain point and then I get the following errors:

<!-- 011 mergecattables:32: Can't alloc 393232 bytes of memory: No error in the
function btmkpage -->
<!-- 011 mergecattables:32: Can't alloc 393232 bytes of memory: No error in the
function btmkpage -->
<!-- 178 mergecattables:38: Trying to insert duplicate value (3b15176049,000010)
in index e:\boarddb\xthreadsfrmthrd.btr -->
<!-- 011 mergecattables:32: Can't alloc 393232 bytes of memory: No error in the
function btmkpage -->
<!-- 011 mergecattables:32: Can't alloc 393232 bytes of memory: No error in the
function btmkpage -->
<!-- 178 mergecattables:38: Trying to insert duplicate value (3b15176049,000013)
in index e:\boarddb\xthreadsfrmthrd.btr -->
<!-- 100 mergecattables:31: Record write failed -->
<!-- 000 mergecattables:38: Could not perform assignment to Body varchar -> v
arblobi in the function Assignment -->
<!-- 000 mergecattables:38: Insufficient values for fields in the function Inser
t -->
<!-- 000 mergecattables:38: SQLExecute() failed with -1 in the function execntex
is -->
<!-- 100 mergecattables:31: Record write failed -->
<!-- 000 mergecattables:38: texis ABEND exception 0xC0000005 (ACCESS_VIOLATION)
-->

Is there error caused by a memory problem?

[John]

It sounds as if you may be running out of memory. If you are doing large <SQL> loops are you using the ROW option when you are selecting, and NOVARS on the inserts and updates to ensure that you are not bringing the entire table into memory?

[sourceuno]

I used the ROW option and NOVARS on inserts/updates but I still get the ABEND exception. Are there any other ways to optimize the script without getting the error?

[John]

Can you provide the script you are using? Since this may take a little investigation it would be helpful just to open it as a tech support ticket on the tech support page.

Thanks