× 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.



On 19-Nov-2013 12:09 -0800, Vernon Hamberg wrote:
DS will not show you tables that are created without DDS or DDL -
where you use CRTPF with record length - that makes it a bit
unhelpful.
I know, some might say those are not tables! Sobeit!
<<SNIP>>

Any SQL tooling dependent upon, implemented using, the SQL catalogs, will suffer the same issue... as well as being unable to list the files created in the QTEMP library. FWiW: The non-externally-described [aka program-described] database files are not only those created using RCDLEN() on the Create Physical File (CRTPF) command. And they are all excluded from SYSTABLES [SQLTables() API] requests irrespective the means used to create them, because of the WHERE clause logic which includes DBXREL='Y'; i.e. only the potentially /relational/ database files, those that are externally described by DDL or DDS, are provided to a client\requester, and all conspicuously non-relational database [physical or logical] *flat files* are not provided to a requester.


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
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.