× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. February 2017

Re: SQL statements for physical and logical files

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.




As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.