Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

RI validation on create time

2 posts in Product Futures Discussion Last posting was on 2003-07-04 15:40:20.0Z
Leonardo Pasta Posted on 2003-07-04 12:36:44.0Z
From: "Leonardo Pasta" <lhpasta@performinformatica.com.br>
Subject: RI validation on create time
Date: Fri, 4 Jul 2003 09:36:44 -0300
Lines: 5
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-Mimeole: Produced By Microsoft MimeOLE V6.00.2800.1165
Message-ID: <OmYINoiQDHA.331@forums-2-dub>
Newsgroups: sybase.public.ase.product_futures_discussion
NNTP-Posting-Host: 200.203.179.70
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1271
Article PK: 95511

Would be really nice to see an option on the "alter table .... add
constraint" for FK creation, an option to validate if the existing data
conforms to the constraint being created.


Bret Halford Posted on 2003-07-04 15:40:20.0Z
Message-ID: <3F059FE4.A9B34397@sybase.com>
Date: Fri, 04 Jul 2003 09:40:20 -0600
From: Bret Halford <bret@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.76 [en] (Windows NT 5.0; U)
X-Accept-Language: en,ja
MIME-Version: 1.0
Subject: Re: RI validation on create time
References: <OmYINoiQDHA.331@forums-2-dub>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.ase.product_futures_discussion
NNTP-Posting-Host: vpn-dub-051.sybase.com 10.22.120.51
Lines: 8
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1272
Article PK: 95515


Leonardo Pasta wrote:
>
> Would be really nice to see an option on the "alter table .... add
> constraint" for FK creation, an option to validate if the existing data
> conforms to the constraint being created.

There is a feature request CR open for this, CR 289567.

-bret