USE (DATAPATH + IMPORT_DIR + BSTRANS_DIR + laBSTrans[m.i, 1]) IN 0 ALIAS new_bstrans

SELECT new_bstrans
*** There is not enough memory to complete this operation.
*** ====>>> Need to determine the limitation here.
COPY TO ARRAY t_array ;
FOR (DATE() - new_bstrans.TransDate) < lnDaysHistory AND ;
!DELETED()

The above COPY TO ARRAY occassionally fails with the not enough memory limitation. The table getting copied to the array is going to vary between files and between days this f(x) is run.

How do I determine the limitation and code around it??

tia, Kim