Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Hi John, dbschema.exe says:
C:\\Informix\\bin>dbschema -t location_non_us -d superstores_demo
DBSCHEMA Schema Utility INFORMIX-SQL Version 9.30.TC2E3
Copyright (C) Informix Software, Inc., 1984-1997
Software Serial Number ACP#A250443
{ TABLE "dom".location_non_us row size = 2044 number of columns = 9 index size =
0 }
create table "dom".location_non_us of type 'dom'.loc_non_us_t
under 'dom'.location;
revoke all on "dom".location_non_us from "public";
...
ALTER TABLE
location_non_us
ADD CONSTRAINT PRIMARY KEY
(
location_id
)
CONSTRAINT
location_non_us_pk
XIX000:-704: Primary key already exists on table.
...
Mysterious.
D.
John Carlson <john_carlson@whsmithusa.com> wrote in message news:<sfkpcv45og0is22c0bid737bkd7ui6f1r4@4ax.com>...
> On 22 May 2003 01:42:03 -0700, dominic.morris@eidosnet.co.uk (dom)
> wrote:
>
> What does dbschema say?
>
> >Hi all,
> >
> >I'm trying to define a primary key on IDS 9.3/9.4 demo database
> >superstores_demo on tables us_location and non_us_location on their
> >SERIAL columns.
> >
> >The engine errors & reports that the tables already have a primary key
> >defined, but I can't see it in the system tables, neither does
> >ServerStudio report these keys' existence.
> >
> >Can anybody explain this, please?
> >
> >Many thanks,
> >dm.
dom wrote in message ...
>Hi John, dbschema.exe says:
>
>C:\\Informix\\bin>dbschema -t location_non_us -d superstores_demo
>
>DBSCHEMA Schema Utility INFORMIX-SQL Version 9.30.TC2E3
>Copyright (C) Informix Software, Inc., 1984-1997
>Software Serial Number ACP#A250443
>{ TABLE "dom".location_non_us row size = 2044 number of columns = 9 index
size =
> 0 }
>create table "dom".location_non_us of type 'dom'.loc_non_us_t
> under 'dom'.location;
The keyword in the line above is UNDER; what you have is a hierarchy.
Take a look at $INFORMIXDIR/demo/dbaccess/demo_ud/c_loc.sql
>...
>
>ALTER TABLE
> location_non_us
>ADD CONSTRAINT PRIMARY KEY
>(
> location_id
>)
>CONSTRAINT
> location_non_us_pk
>
>XIX000:-704: Primary key already exists on table.
Which is true ...
>
>...
>
>Mysterious.
>
>D.
>
>
>John Carlson <john_carlson@whsmithusa.com> wrote in message
news:<sfkpcv45og0is22c0bid737bkd7ui6f1r4@4ax.com>...
>> On 22 May 2003 01:42:03 -0700, dominic.morris@eidosnet.co.uk (dom)
>> wrote:
>>
>> What does dbschema say?
>>
>> >Hi all,
>> >
>> >I'm trying to define a primary key on IDS 9.3/9.4 demo database
>> >superstores_demo on tables us_location and non_us_location on their
>> >SERIAL columns.
>> >
>> >The engine errors & reports that the tables already have a primary key
>> >defined, but I can't see it in the system tables, neither does
>> >ServerStudio report these keys' existence.
>> >
>> >Can anybody explain this, please?
>> >
>> >Many thanks,
>> >dm.
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.