dbschema and dbexport now outputs "contraint ..." syntax
Hi,
When transitioning from Informix 5.X to 7.X for
a client I discovered that the same engine appears
to randamly emit or not emit a new syntax as follows:
5.X always
date_val date not null,
7.X sometimes
date_val date not null constraint "rpts".n100_1,
The real downside is that I can do a dbexport and
then a subsequent dbimport which breaks on the
the "constraint ..." stuff under 7.X, however if
I hand edit the file and remove the constrint stuff
the dbimport succeeds. Not a very good feature.
Both dbexport and dbschema exhibit this behavior,
any idea of what is going on and how to stop it.
- Jon A. Strabala
jon@quantumsi.com
PLEASE also E-MAIL responses - I will repost a summary
****** details follow for a 7.X engine on two differnt boxes *****
(ABNORMAL and UNEXPECTED)
larock{rpts}41: dbschema -d evxref2 -t nodes |& more
DBSCHEMA Schema Utility INFORMIX-SQL Version 7.11.UC1
Copyright (C) Informix Software, Inc., 1984-1995
Software Serial Number AAB#J296540
{ TABLE "rpts".nodes row size = 49 number of columns = 7 index size = 18
}
create table "rpts".nodes
(
date_val date not null constraint "rpts".n100_1,
isactive char(1) not null constraint "rpts".n100_2,
consistent char(1) not null constraint "rpts".n100_3,
node_tag integer not null constraint "rpts".n100_4,
mnemonic_ne_name char(20) not null constraint "rpts".n100_5,
sys_tag integer not null constraint "rpts".n100_6,
dte1_prim char(15) not null constraint "rpts".n100_7
);
revoke all on "rpts".nodes from "public";
create unique index "rpts".nodes_1_uidx on "rpts".nodes
(date_val,node_tag);
(NORMAL and EXPECTED)
betty% dbschema -d evxref2 -t nodes
DBSCHEMA Schema Utility INFORMIX-SQL Version 7.10.UC1
Copyright (C) Informix Software, Inc., 1984-1994
Software Serial Number AAB#J702530
{ TABLE "jchack".nodes row size = 49 number of columns = 7 index size =
18 }
create table "jchack".nodes
(
date_val date not null,
isactive char(1) not null,
consistent char(1) not null,
node_tag integer not null,
mnemonic_ne_name char(20) not null,
sys_tag integer not null,
dte1_prim char(15) not null
);
revoke all on "jchack".nodes from "public";
create unique index "jchack".nodes_1_uidx on "jchack".nodes
(date_val,node_tag);