RE: Physical and Logical Files

Charles,
Because we can update >if< we use a "correlated sub-query",
maybe a view constructed that way would support an
update of a view based on a "join".


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Charles Wilt
Sent: Wednesday, October 03, 2012 10:51 AM
To: RPG programming on the IBM i / System i
Subject: Re: Physical and Logical Files

Ok, I take it back....

I could have sworn I'd done this in the past....basically as long as the DB could tie each record in the joined LF to a single record in the PF it would allow you to update (that's how join SQL views work)...

But in searching for a reference all I find is posts saying it can't be done...

Sorry!
Charles

On Wed, Oct 3, 2012 at 11:51 AM, James Lampert <jamesl@xxxxxxxxxxxxxxxxx> wrote:

Charles Wilt wrote:

Joined views can be update-able....as can joined logicals...

Huh?!? Did you just say that DDS join-logicals can now be opened for
update? When did that happen? And with what constraints on what can be
done? I think I missed that "Memo to Users."

--
JHHL
--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing
list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/rpg400-l.

--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at http://archive.midrange.com/rpg400-l.