RE: Override PF in view

Are you saying to replace the table in the view (e.g. MYLIB.TABLE1) with an alias?


Sample:
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
)

Select *
From JOIN_VIEW





-----Original Message-----
From: Vernon Hamberg [mailto:vhamberg@xxxxxxxxxxxxxxx]
Sent: Thursday, January 26, 2017 4:30 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: Re: Override PF in view

Hi Justin

I'll take a WAG at this. You probably all this, but ...

When you create a view, all you have is the SELECT statement encapsulated in what is basically a logical file - with no data, no entries.

There is no connection to any kind of override when the view is used - the SELECT statement is run at that time.

So maybe create an ALIAS and refer to that instead of the PF in the SELECT statement.

Maybe???

Vern