Re: Join & Update

["R. Bruce Hoffman, Jr." <rbruceh@xxxxxxx>]

Not a dumb question, but a join operation is not updatable, period. This has
always been a "future objective" of database, but don't hold your breath.

The reason to design to third normal form is to prevent update anomolies.
The reason to use joins is to put the data in 2nd normal form for usage.
Thus, the join form re-introduces update anomolies to the process, hence, no
update.

-----Original Message-----
From: Sethuraman <sethu@bc.sympatico.ca>
To: RPG400-L@midrange.com <RPG400-L@midrange.com>
Date: Monday, October 18, 1999 2:09 AM
Subject: Join & Update


>Hi Folks:
>
>A join logical file cannot be used for Update.
>
>What about SQL?  If a view (with joins) is created using SQL, can this view
be
>declared
>as an "Update"? Or is this a dumb question?
>





===========================================================
R. Bruce Hoffman, Jr.
 -- IBM Certified AS/400 Professional System Administrator
 -- IBM Certified AS/400 Professional Network Administrator

"The sum of all human knowledge is a fixed constant.
    It's the population that keeps growing!"



+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---