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.
Stefan Weideneder — — source: Informix-list mailing list archive (1991-1998)
Hi,
if you want to create your clustered index you should follow the steps:
1.) drop the primary key constraint ( this will drop the index, too ).
2.) create an UNIQUE CLUSTER index.
3.) update statistics for that table
4.) finally add your primary key definition
Before you add a primary key/foreign key constraint you should
always create the indexes by yourself.
Be carefull ! Informix will generate it's own indexes (for the
pk/fk constraints ) if you would drop ( re-create ) your indexes
afterwards, if you would not drop your constraints before.
Bye
Stefan
PS: "dbschema" will NOT destroy the order :
create table - create index - alter table add primary key
Reghu R. Nair wrote:
>
> Friends,
> I'm trying to change unique index in a table to unique clustered
> index using dbaccess in informix online dynamic server 7.12.
>
> I've used 'ALTER INDEX index-name TO CLUSTER'.But it is giving
> me a syntax error(-201).The index also happens to be the primary key
> and its name is 105_14(since i've not given any explicit create index
> statement).
> Then i tried dropping the index using 'Drop index 105_14'.
> But it gave me the same syntax error.What am i missing here?
> Any help in this matter would be greatly appreciated.
>
> Thanks in advance
> Reghu R.Nair
>
> mailto:reghu@comsysmgt.com
>
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.