Re: Constraint based upon a separate file

[rpglist@xxxxxxxxxxx]

Again Thanks Rob.... along with everyone else....  some things get a little fuzzy at times.....


On Sep 20, 2012, at 7:19 AM, rob@xxxxxxxxx wrote:

> Look up "referential constraint" at one of these locations:
> http://publib.boulder.ibm.com/infocenter/iseries/v7r1m0/topic/db2/rbafzatabl.htm
> http://publib.boulder.ibm.com/infocenter/iseries/v7r1m0/topic/db2/rbafzhctabl.htm
> http://publib.boulder.ibm.com/infocenter/iseries/v7r1m0/topic/cl/addpfcst.htm
>
>
> Rob Berendt
> -- 
> IBM Certified System Administrator - IBM i 6.1
> Group Dekko
> Dept 1600
> Mail to:  2505 Dekko Drive
>          Garrett, IN 46738
> Ship to:  Dock 108
>          6928N 400E
>          Kendallville, IN 46755
> http://www.dekko.com
>
>
>
>
>
> From:   rpglist@xxxxxxxxxxx
> To:     midrange-l@xxxxxxxxxxxx, 
> Date:   09/19/2012 06:27 PM
> Subject:        Constraint based upon a separate file
> Sent by:        midrange-l-bounces@xxxxxxxxxxxx
>
>
>
> I know how to add a typical check constraint where it ensures that the
> value matches a short list of codes, etc.  I have been searching for the
> past few hours to no avail for an example that shows how to add a check
> constraint based upon the value in a separate file:
>
> Quick and dirty example would be a state field of two characters that has
> to match a predfined table of state abbrev's or a zipcode lookup table...
>
> Does anyone have any examples I can reference?  I have been all over the
> reference manual and so far haven't found what I'm looking for.
>
> Thanks,
>
> C
>
> -- 
> 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.
>
>
> -- 
> 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.