DBIMPORT REPORTS ERROR " IMPORT DATA IS CORRUPTED!

yangsy

revoke all on "informix".loc_items from "public";

create unique index "informix".ix_loc_item_id on "informix".loc_items
    (item_id);
create index "informix".ix_loc_item_loc on "informix".loc_items
    (loc_id);
alter table "informix".loc_items add constraint primary key (item_id)
     ;
{ TABLE "informix".loc_history row size = 44 number of columns = 8 index size =
75
              }
{ unload file name = loc_h00107.unl number of rows = 9528 }

create table "informix".loc_history
  (
    item_id serial not null ,
    loc_id integer not null ,
    prev_id integer,
    user_id integer,
    item_type varchar(9),
    type varchar(9),
    start_date date not null ,
    end_date date
  );
revoke all on "informix".loc_history from "public";

create index "informix".ix_loch_loc_id on "informix".loc_history
    (loc_id);
create index "informix".ix_loch_previd on "informix".loc_history
    (prev_id);
create index "informix".ix_loch_uid on "informix".loc_history
    (user_id);
create index "informix".ix_loch_lt_id on "informix".loc_history
    (loc_id,item_type);
create unique index "informix".ix_loch_item_id on "informix".loc_history
    (item_id);
{ TABLE "informix".inventory row size = 50 number of columns = 6 index size = 72

              }
{ unload file name = inven00108.unl number of rows = 72645 }

create table "informix".inventory
  (
    ware_id integer not null ,
    prod_id integer not null ,
    quantity integer
        default 0,
    average_p money(16,2)
        default 0.00,
    manual_p money(16,2)
        default 0.00,
    status varchar(19) not null
  );
*** Import data is corrupted!

0 - Unknown error message 0.


不知道是怎么回事, 请各位大虾相救

99hd

我也遇到相同的问题了，大家帮帮忙啊！
这是怎么回事呢？该如何解决阿？

华光骑士

先别导这张表了，它可以在最后load，看看到底是那行纪录出了问题。你可以修改dmexpor.exp目录中的<db_name>.sql ，把这个表的信息先去掉。

tradewind

估计是有乱码，先手工建表，用load插表就知道哪一行有问题了

fush76

{ unload file name = loc_h00107.unl number of rows = 9528 }

以上行的rows=????
与你的unl记录的行数不一致.

baixifeng

原帖由 fush76 于 2006-2-13 14:38 发表
{ unload file name = loc_h00107.unl number of rows = 9528 }

以上行的rows=????
与你的unl记录的行数不一致.

应该是这个原因。