Re: SQL statements for physical and logical files

[Peter Dow <petercdow@xxxxxxxxx>]

I agree. In fact, I find it curious that they store it for SQL Views but 
not for SQL Tables or Indexes. And as you say, DDS PFs and LFs.


On 2/12/2017 9:33 PM, Vernon Hamberg wrote:
> OK - I guess I did not consider views to be in the scope of the 
> question - in the limited scope of the statement, I'll still hold to 
> its validity - there is no SQL CREATE statement stored anywhere for 
> DDS-based PFs and LFs.
>
> On 2/12/2017 1:52 PM, Peter Dow wrote:
> > It was tail end of this that prompted me to reply:
> >
> >
> > On 2/11/2017 12:54 PM, Vernon Hamberg wrote:
> > > the fact that you can generate (not retrieve) the SQL statement that 
> > > will create the equivalent of a PF or LF does not mean that the 
> > > statement is stored anywhere. I'm very sure the statement is not 
> > > stored.