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

> On 1/26/2017 4:39 PM, Justin Taylor wrote:

I have a view that joins three PF's. I now need to override one of those PF's. We tried OVRDBF, but it doesn't seem to. Any way to get there from here?

Thanks