RE: Override PF in view

That would work. The downside being we'd have to delete and recreate the views when the underlying table was deleted.



-----Original Message-----
From: Mark S Waterbury [mailto:mark.s.waterbury@xxxxxxxxxxxxx]
Sent: Friday, January 27, 2017 10:52 AM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: Override PF in view

Justin:

Suppose this is your original view:

Create view JOIN_VIEW as (
Select * from MYLIB.TABLE1 A
Join select * from MYLIB.TABLE2 B on A.ID = B.ID
Join select * from MYLIB.TABLE3 C on B.ID = C.ID
)

Now, create an alternate view that uses the "other" table (or PF), e.g.:

Create view JOIN_VIEW2 as (
Select * from MYLIB002.TABLE1A A
Join select * from MYLIB.TABLE2 B on A.ID = B.ID
Join select * from MYLIB.TABLE3 C on B.ID = C.ID
)

Then, you can issue:

OVRDBF FILE(JOIN_VIEW) TOFILE(JOIN_VIEW2)

and run your program or query as before, and that should do what you want ...

Hope that helps,

Mark S. Waterbury