Re: DSPDBR via SQL view

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Nice find, Kevin - I still wonder if it reports relations, or only those 
that are about database objects created with SQL DDL = and not created 
using DDS.

Cheers
Vern

On 6/10/2020 5:56 PM, Kevin Wright wrote:
> I have just run DSPDBR QADBFDEP on my machine.
>
> It came up with SYSVIEWDEP in QSYS2.
>
> WRKOBJPDM then EA and F11 a couple of times shows that on V7R3 it appears
> to have *PUBLIC *READ
>
> The SQL to query that is up to you.
>
>
>
> > -----Original Message-----
> > From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
> > smith5646midrange@xxxxxxxxx
> > Sent: Tuesday, 9 June 2020 12:19 PM
> > To: 'Midrange Systems Technical Discussion'
> > <midrange-l@xxxxxxxxxxxxxxxxxx>
> > Subject: DSPDBR via SQL view
> >
> > Does anyone know if there is an SQL view that will provide all of the
> > logicals and indexes built over a physical file?  Basically I'm looking
> for
> > an IBM view that gives me what DSPDBR to an outfile gives me.  I know
> there
> > is a file out there named QADBFDEP but it is locked down by default and
> I
> > need something accessible by a PGMR or USER profile.