Re: File not in QSYS2.SYSTABLES

I'm sorry John, I'm not trying to be dismissive. Neither you nor your
questions are stupid. I share your pain. There is definitely a lot in the
Catalog that is IBM i specific, but logical files are not well supported. I
would like to see them more fully supported as well, and even keyed
physical files.

On Mon, Oct 7, 2019 at 6:37 PM John Yeung <gallium.arsenide@xxxxxxxxx>
wrote:

On Mon, Oct 7, 2019 at 6:03 PM Mark Murphy <jmarkmurphy@xxxxxxxxx> wrote:

But logical files only find their way into the catalog as tables, and the
key fields for them do not appear anywhere.

I am not appreciating the dismissiveness of your responses.

Are you trying to explain to me why my question is stupid, or are you
trying to help me? It sure doesn't sound like the latter.

If the full notion of "logical file" is not "really an SQL concept"
but they still make it into the catalog as tables (and they are even
differentiable from physical files and from "true" SQL tables), then
it seems to me that *some* accommodation *could* have been made for
multiformat files as well. It seems pretty arbitrary what gets
included and what doesn't, so when your response amounts to "it
doesn't make sense for your missing files to be in the catalog", that
is neither illuminating nor satisfying.

You also conveniently seem to "not hear" the part where I also mention
IBM i Services, which is CHOCK FULL of stuff that has nothing at all
to do with SQL, yet which IBM has made accessible ***through SQL***.

I'm just interested in finding out if there is *some* way through SQL
for me to find these files. If there isn't, then there isn't. But
don't give me some curt and flimflam "reasoning" for it.

John Y.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com