Re: Insure DB consistency in case of recovery

[Vernon Hamberg <vhamberg@xxxxxxxxx>]

At 10:23 AM 4/13/02 -0400, you wrote:
>Heba & Rob & Vernon & others
>

-snip-

>Short answer for Vernon ... The manual implies that both check constraints &
>referential integrity is imposed against anything that accesses the DB,
>including SQL.  But like I said at the outset, I am merely a student of this
>topic.

Right. Once there were no constraints in DB2/400 - it wasn't even called
that then, it was just the AS/400 database. But there were DDS keywords
that might LOOK like they are check constraints. They are not. What they do
is work in conjunction with display files, for values checks there. But
they don't prevent erroneous values coming from SQL or RPG or whatever.
This has caused me some confusion.

Check PF constraints DO accomplish this - coolness!