Clustered Index

Posted in 1997

"Reghu R. Nair" — 22 Oct 1997 15:43:12 -0400 — source: Informix-list mailing list archive (1991-1998)

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 Computer Systems Management 205 south whiting street Suite 201 Alexandria VA 22304

Related threads

Force Assert Fail
IDS Function problem