Re: dbschema and dbexport now outputs "contraint ..." syntax
In article <33319540.41C67EA6@quantumsi.com>, Jon Strabala
<jon@quantumsi.com> writes
>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
It is a bug - I experienced this on Online 7.1x on a Dec Alpha.
Talk to Informix for an upgrade to fix the problem.
A dbexport should always be dbimport-able.
> );
>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);
--
David Williams