Unix Technical Forum

RE: constraint to allow multiple nulls

This is a discussion on RE: constraint to allow multiple nulls within the Informix forums, part of the Database Server Software category; --> Some DDL and example rows please. -----Original Message----- From: owner-informix-list@iiug.org [mailto wner-informix-list@iiug.org] On Behalf Of Zev Berezin Sent: Wednesday, ...


Go Back   Unix Technical Forum > Database Server Software > Informix

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-20-2008, 09:57 AM
Konigsberg, Jay
 
Posts: n/a
Default RE: constraint to allow multiple nulls



Some DDL and example rows please.

-----Original Message-----
From: owner-informix-list@iiug.org [mailtowner-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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 10:16 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com