I've tried execute a copy sql statement ang dbsys give me that error.
I need copy data from many to one table.
My sql statement is:

insert into ALL_DATA
(
  "CODE",
  "IMAGE",
  "VOLUME" )
select
  "CODE",
  "IMAGE",
  "VOLUME" from DATA_01

The table DATA_01 has a blob field with an image data.

In the second step od progress bar dbsys give me the "Out of memory" error.

How can I solve this problem?

Thanks a lot!!

Have you tried small Commit Interval ?  (I believe Version 3 had this
feature)
You may be choking the engine if these are large files... hth.

"alijunior" <alijunior@alijunior.com> wrote in message
news:913B7EDC-E5EA-4400-83FB-CA6A9C727996@news.elevatesoft.com...
> I've tried execute a copy sql statement ang dbsys give me that error.
> I need copy data from many to one table.
> My sql statement is:
>
> insert into ALL_DATA
> (
>   "CODE",
>   "IMAGE",
>   "VOLUME" )
> select
>   "CODE",
>   "IMAGE",
>   "VOLUME" from DATA_01
>
> The table DATA_01 has a blob field with an image data.
>
> In the second step od progress bar dbsys give me the "Out of memory"
> error.
>
> How can I solve this problem?
>
> Thanks a lot!!
>

<< I've tried execute a copy sql statement ang dbsys give me that error. I
need copy data from many to one table.
My sql statement is: >>

Is the target table an in-memory table ?  If so, then you're probably just
inserting too much data for an in-memory table.

--
Tim Young
Elevate Software
www.elevatesoft.com