Re: More fun with native RLA on an SQL view

[CRPence <CRPbottle@xxxxxxxxx>]

James H. H. Lampert wrote:
> CRPence wrote:
> > <<SNIP>>
>
> <<SNIP>>
>
> > The query debug messages might give some insight; i.e. to
> > reproduce the scenario might require the same implementation.
>
> Hmm. I vaguely recall those being covered at some length at the
> class I attended in Rochester, but it's been a few years. Would
> we be getting query debug messages at access time, going through
> RLA, or just at creation time? It sounds like something that
> might also be of some help on the problem I posted on the MI
> list.

  The SQL SELECT as "query" is encapsulated in the VIEW, and that 
query is run at file OPEN time.

  For example, perform the following scripted CL invocations, then 
review the spooled joblog with second level text:

    strdbg *none
    opndbf *libl/syscolumns *inp commit(*no) opnid(s)
    clof s

Regards, Chuck