Re: Can I have check and referential constraint on same column?

[Luis Rodriguez <luisro58@xxxxxxxxx>]

AFAIK, yes.

Regards,

Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries


On Thu, May 20, 2010 at 11:22 AM, <Rick.Chevalier@xxxxxxxxxxxxxxx> wrote:

> I have come across a situation where I think I need both a check constraint
> and a referential constraint on the same column to handle different
> situations.
>
> When a row is inserted the default value for the status column will be 'N'.
>  When the information has been validated it will change to 'V'.  This is my
> current check constraint.
>
> If the validation is overridden an override code can be placed into the
> status column from an exception table.  This is my referential constraint.
>
> I have thought about adding the check values to the exception table and
> excluding them from the exception prompt but I would prefer to handle it
> without doing that if possible.  If I can't have both constraints on the
> status column this is probably what I will do.
>
>
> Rick Chevalier
> IT Software Solutions - Loan Servicing
>
>
>
> ________________________________
> Privileged and Confidential. This e-mail, and any attachments there to, is
> intended only for use by the addressee(s) named herein and may contain
> privileged or confidential information. If you have received this e-mail in
> error, please notify me immediately by a return e-mail and delete this
> e-mail. You are hereby notified that any dissemination, distribution or
> copying of this e-mail and/or any attachments thereto, is strictly
> prohibited.
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.