Re: File not in QSYS2.SYSTABLES

[John Yeung <gallium.arsenide@xxxxxxxxx>]

On Tue, Oct 8, 2019 at 12:54 PM Peter Dow <petercdow@xxxxxxxxx> wrote:
> And just to add to the discussion, SYSTABLES is itself an SQL VIEW. You
> can do DSPFD QSYS2/SYSTABLES to see the SQL statement used to create it,
> and in that you will see the FROM files Rob mentioned, as well as the
> WHERE clause that apparently excludes SQL VIEWS. Given that, you could
> create your own view with different selection criteria.

Now we're really pulling back the curtain on Oz! This is great stuff, thanks.

John Y.