- 论坛徽章:
- 0
|
建表的时候没指定dbspace，但建库的时候指定了datadbs的，应该没问题吧，最后一个字段byte型
执行的sql就是 alter table wastebook1 modify ( transerialid varchar(9) );
{ TABLE "informix".wa1 row size = 193 number of columns = 16 index size = 315 }
create table "informix".wa1
(
frontid varchar(1),
transerialid varchar(7),
serviceserialid varchar(2),
frontrecycle varchar( ,
sourcenodeid varchar(10) not null ,
channelsys varchar(10),
channelwasteid varchar(19),
channelrecycle varchar(,
tranid varchar(6),
servicesys varchar(10),
servicewasteid varchar(19),
servicerecycle varchar(,
serviceid varchar(10),
transtatus varchar(1) not null ,
flowstatus varchar(1) not null ,
servicedata byte
);
revoke all on "informix".wa1 from "public";
create unique index "informix".tranindex3_1 on "informix".wa1
(transerialid,serviceserialid,frontrecycle,frontid) using
btree ;
create unique index "informix".tranindex3_2 on "informix".wa1
(channelwasteid,serviceserialid,channelsys,channelrecycle)
using btree ;
create index "informix".tranindex3_3 on "informix".wa1 (frontrecycle)
using btree ;
create index "informix".tranindex3_4 on "informix".wa1 (frontrecycle,
transerialid) using btree ;
create index "informix".tranindex3_5 on "informix".wa1 (servicesys,
servicewasteid,servicerecycle) using btree ;
create index "informix".tranindex3_6 on "informix".wa1 (servicewasteid,
servicerecycle,servicesys,serviceid) using btree ; |
|
免费注册
发表于 2009-01-16 15:03
