Re: Data Warehouse and Constraints

From: Kevin S. DeWitt <ksdewitt_at_mindspring.com>
Date: 1997/12/19
Message-ID: <349A79F0.295D@mindspring.com>#1/1

Phil Herring wrote:
>
> In article <882370395.2082996227_at_dejanews.com> , shawe_at_indy.tce.com writes:
<snip>

> Why don't you use:
>
> ALTER TABLE BLAH ENABLE CONSTRAINT FOO EXCEPTIONS INTO BAR;
>
> That way, the bad rows are written to BAR, and the statement doesn't fail.
>
> ---------------------------------------------------------------------------
> Copyright 1997 Phil Herring. This article may not be reproduced for profit.
> ---------------------------------------------------------------------------

Actually, the documentation for ENABLE CONSTRAINT foo EXCEPTIONS INTO bar states that rows are listed, not moved to bar and and that the constraint remains disabled!

-- 
 Kevin S. DeWitt            Actium
 ksdewitt_at_mindspring.com    101 North Meadows Dr
 1-888-504-8048 x5006       Suite 113
 http://www.actium.com      Wexford, PA  15090

Received on Fri Dec 19 1997 - 00:00:00 CST