Re: RPG Native IO with SQL unique constraint

[Charles Wilt <charles.wilt@xxxxxxxxx>]

Note for the archives....

It appears that Oracle added support for deferrable constraints
because Oracle doesn't support ON UPDATE CASCADE for primary/foreign
key constraints.

-Charles


On Wed, Sep 9, 2009 at 11:02 AM, Charles Wilt<charles.wilt@xxxxxxxxx> wrote:
> Yep.
>
> Odd? Perhaps if you used to working with Oracle....
>
> Honestly, I can see the benefits and the thought process behind the
> idea, but I've never needed them.
>
> -Charles
>
> On Wed, Sep 9, 2009 at 10:29 AM, <BMay@xxxxxxxxx> wrote:
> > So you are saying that DB2 will check constraints before I COMMIT to the
> > DB.  That seems odd.
> >
> > Brian May
> > Project Lead
> > Management Information Systems
> > Garan, Incorporated
> > Starkville, Mississippi
> >
> > Young i Professionals
> > http://www.youngiprofessionals.com