RE: Physical and Logical Files

[Gary Thompson <gthompson@xxxxxxxxxxx>]

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.