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.
This mailing list archive is Copyright 1997-2025 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.
midrange.com
