RE: constraint to allow multiple nulls

Posted in 2005

Konigsberg, Jay — Wed, 3 Aug 2005 16:08:53 -0700 — source: Usenet: comp.databases.informix

Some DDL and example rows please. -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Zev Berezin Sent: Wednesday, August 03, 2005 2:18 PM To: informix-list@iiug.org Subject: constraint to allow multiple nulls Hi All, I have a column that can only have one 'Y' value and multiple NULL values. An unique constraint allows one null value and a PK allows none. Is there any constraint that would enforce this? Tech Spec: IDS 7.31.FD7 TIA, Zev Berezin sending to informix-list sending to informix-list