× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



42

Paul Nelson
Cell 708-670-6978
Office 409-267-4027
nelsonp@xxxxxxxxxxxxx


-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Danny
Hayes
Sent: Tuesday, May 23, 2017 6:01 AM
To: Midrange Systems Technical Discussion
Subject: RE: Ref constraint: Numeric to Character

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


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.