A column in a primary key cannot be null.
1. Update that column so it is not null.
2. Unload and delete rows with null.
MW
> -----Original Message-----
> From: owner-informix-list@iiug.org
> [mailto:owner-informix-list@iiug.org]On Behalf Of Bill Hamilton
> Sent: Thursday, 4 September 2003 3:12 a.m.
> To: informix-list iiug
> Subject: Changing Primary Index Question
>
>
> GlacierYesterday I had to add a column to a table that had a 3-column
> primary index
> and this new column (a nullable column) had to become part of
> the primary
> key.
> The only way I could make it happen was to unload the table
> with null in
> that spot,
> drop the table, add the table, reload the table, add put back
> all other
> contraints.
>
> Just for my future reference, is there an easier way (under
> IDS 7.31) ?
>
> sending to informix-list
sending to informix-list