RE: Logical File or OPNQRYF or anyother way ? -Legacy iSeriesFlatFiles

["Joe Pluta" <joepluta@xxxxxxxxxxxxxxxxx>]

You're right, Rob.  I think I was thinking more along the lines that you
can create your entire database without constraints and still use it
just fine.  But as Charles points out, you can do that in any RDBMS.  So
in fact, the iSeries seems pretty solid from a rule 12 standpoint.
Thanks for pointing that out.

Joe


> From: rob@xxxxxxxxx
> 
> Regarding rule 12:  "Codd's 12th rule specified that an RDBMS
> should not be accessible in a way that subverts its constraints and
> integrity rules."
> Using traditional RPG on a file does not violate rule 12.  If I use
> constraints, and referential integrity, RPG will NOT allow you to
bypass
> the constraints and RI.
> True?  If your testing shows otherwise, enlighten me.  It just
requires
> that you do a little more checking, and a little less ASSUMption when
you
> do a WRITE or an UPDATE and the operation fails.
> Heck, I can't even violate these rules using UPDDTA, WRKDBF, etc.