Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Location
    UK
    Posts
    3

    Unanswered: loading data in Informix XPS

    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.

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780

    Re: loading data in Informix XPS

    Originally posted by jurie
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •