Re: SQL Delete with JOIN

[CRPence <CRPbottle@xxxxxxxxx>]

On 14 Dec 2012 12:17, CRPence wrote:
> <<SNIP>> My recollection of the relational "rules" is that a RDBMS
> should /understand/ that a JOIN [VIEW] is "updateable". Creating that
> VIEW using JOIN syntax instead, does not Allow Delete\Update... on
> v5r3. Perhaps the DB2 for i Database SQL might allow the DELETE
> statement without having to first CREATE TRIGGER ... INSTEAD OF
> DELETE.

  That should have said "Perhaps *newer versions of* the DB2 for i 
Database SQL might allow the DELETE statement *against the JOIN VIEW*
without having to first CREATE TRIGGER ... INSTEAD OF DELETE."