RE: This may be a simple newbie question, but..... (about Indexes

Sounds like you're needing something like: create unique index index_name on table_name(column_1, column_2, column_3) John Carlson Informix DBA EDS - WHSmith USA 3200 Windy Hill Road, Suite 1500 West Atlanta, GA 30330 > -----Original Message----- > From: Tony! [mailto:NoSpam@Thank.You.com] > Sent: Friday, August 25, 2000 10:53 AM > To: informix-list@iiug.org > Subject: This may be a simple newbie question, but..... > (about Indexes) > > > I'm working with Informix Dynamic Server Version 7.30.UC8 on an AIX > machine. > > I have a table with about 3 fields that I want to create a Unique > index on using sql. > > If I try to insert or update a record so that the three fields match > the three fields on any other record, refuse to accept it as an entry. > > I know that I can make individual fields unique but how do I set 3 as > a group? > > I've been looking at cluster indexes, but I'm not sure if this is what > I would need to use or understand much about cluster indexes. > > Help? > > > Tony! >