load from external table whith blob
Hi!
We are trying to do some table movements using external tables, but when we
try to load some records from an external table with blob, we caught this
error:
-26214 Cannot perform this operation on an external table.
script:
CREATE EXTERNAL TABLE table_ext SAMEAS table
USING
(DATAFILES
(
"DISK:/home/informix/movlog_ext.unl;BLOBDIR:/home/informix/blobmovlog;CLOBDIR:/h
ome/informix/clobmovlog;"
),
REJECTFILE "DISK:/home/informix/movlog_ext.rej",
format "delimited", delimiter "|"
);
insert into table_ext
select first * from table;
create raw table table_new
(
data datetime year to second,
codigo smallint not null ,
tipo varchar(30),
descricao text
);
insert into table_new
select * from table_ext;
This load supposed to works? What am I doing wrong?
Except for "table" being a keyword, I don't see anything wrong. It all looks good to me.