Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
2 replies Latest Post - ‏2013-02-27T08:45:13Z by MarkOrmos
MarkOrmos
MarkOrmos
20 Posts
ACCEPTED ANSWER

Pinned topic Check constraint for a single column

‏2013-02-26T15:18:51Z |
Hi,

I would like to add a check constraint to a single column, but I can't see an option for it.
For instance the column YN_Column can only accept the values Y or N.

How can I do it? Can you help me with it?

Thank you for your help!
Best regards
Mark
Updated on 2013-02-27T08:45:13Z at 2013-02-27T08:45:13Z by MarkOrmos
  • SystemAdmin
    SystemAdmin
    374 Posts
    ACCEPTED ANSWER

    Re: Check constraint for a single column

    ‏2013-02-26T16:19:52Z  in response to MarkOrmos
    Hi, Mark.

    You want to add a check constraint to the table which contains the column. Then enter the check condition as the expression.

    Don