RE: Ref constraint: Numeric to Character

[Danny Hayes <Danny_Hayes@xxxxxxxxx>]

The guy right after 8.

Thanks & Regards,
Danny Hayes
IT-Developer
Genuine Parts Company, APG IT


3100 Windy Hill Road
Atlanta, Georgia 30339
mailto:Danny_Hayes@xxxxxxxxx
(904) 502-2969

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Rob Berendt
Sent: Tuesday, May 23, 2017 6:59 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: Re: Ref constraint: Numeric to Character

Who is '9'?


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:   Booth Martin <booth@xxxxxxxxxxxx>
To:     Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date:   05/22/2017 02:27 PM
Subject:        Re: Ref constraint: Numeric to Character
Sent by:        "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



Can you set a restraint where only characters equal to blank or greater 
than 'Z' are allowed '9'?


On 5/22/2017 8:04 AM, Justin Taylor wrote:
> I have a DDS PF that is keyed on a character field that contains only 
numerics.  I have a DDL PF that has a primary key over a numeric type 
column.  I'm trying to create a referential constraint, with the DDS PF 
being the parent.
> Changing either of the PF's is not an option.  I'm wondering about 
creating a derived field in the DDS PF, but I'm not sure if that's even 
possible.  Any thoughts?
> Thanks