Hi,

I am testing a load process in Informix XPS 8.40 which can load my data much faster into a production table.
I execute the following statements which works fine until the last
alter fragment.
Any ideas ??
thanks
Jurie


alter fragment on table twdp0d
detach p0d12dbs p0d_fragment;

alter table p0d_fragment type (raw);

drop table twdp0d_ext;
create external table twdp0d_ext
sameas twdp0d
using ( FORMAT 'DELIMITED',
DATAFILES
("DISK:4:/dump/twdp0d.20031103"),
REJECTFILE "/dump/twdp0d_ext1.rej.%c",
EXPRESS
);

INSERT INTO p0d_fragment SELECT * FROM twdp0d_ext;

alter table p0d_fragment type (operational);

alter fragment on table twdp0d
attach p0d_fragment
as
((proc_dt <= DATE ('30.11.2003' )) AND (proc_dt >= DATE ('01.11.2003' ))) ;

783: Cannot attach because of incompatible schema.

Hi,

I think that the sentence "create external table" have default, that the other table not. Or the primary table have constraint that the external not.
Proved You with HPL of Informix ?.

Gustavo.