Antwort: [DB2-L] RI on where not null parent. ZOS DB2V8

Rodney Krick

Antwort: [DB2-L] RI on where not null parent. ZOS DB2V8


Neff,

no, it's not. To set RI you need a primary key or an unique constraint in
your parent table. And you cannot define a unique constraint for a column
that allows nulls.

Mit freundlichen Grüßen / Best regards,

Rodney Krick
Senior Consultant
____________________________
aformatik Training & Consulting GmbH & Co. KG
Tilsiter Str. 8, D-71065 Sindelfingen, Germany
Tel.: +49 (0)7031-23 807-0
Fax: +49 (0)7031-23 807-19

mailto:[login to unmask email]
___________________________________________
AITP Authorized Independent Training Provider for IBM Software
____________________________________________
Kommanditgesellschaft mit Sitz in Sindelfingen
Amtsgericht Stuttgart HRA 242677
USt-Id. Nr.: DE 814174749
pers. haftende Gesellschafterin: aformatik Verwaltungs-GmbH
Geschäftsführer: Dipl. Inform. Andreas Anglett
Sitz in Sindelfingen, Amtsgericht Stuttgart HRB 245894



-----DB2 Data Base Discussion List <[login to unmask email]> schrieb: -----


An: [login to unmask email]
Von: Neff Stephen R <[login to unmask email]>
Gesendet von: DB2 Data Base Discussion List <[login to unmask email]>
Datum: 12/18/2007 06:48PM
Thema: [DB2-L] RI on where not null parent. ZOS DB2V8

Hello, Is it possible to create RI using a parent column which is unique
where not null. This ZOS DB2V8.

Thanks

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L
list archives, the FAQ, and delivery preferences are at
http://www.idug.org/lsidugunder the Listserv tab. While at the site, you
can also access the IDUG Online Learning Center, Tech Library and Code
Place, see the latest IDUG conference information, and much more. If you
have not yet signed up for Basic Membership in IDUG, available at no cost,
click on Member Services at http://www.idug.org/lsms
The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms