You can write an UDTF (user defined table function) based on the QDBLDBR
System API.
I've done it a few years ago, but unfortunately I cannot share the source
code.
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
?Train people well enough so they can leave, treat them well enough so they
don't want to.? (Richard Branson)
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
smith5646midrange@xxxxxxxxx
Sent: Donnerstag, 11. Juni 2020 01:24
To: 'Midrange Systems Technical Discussion' <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: RE: DSPDBR via SQL view
Sorry, I meant to say that only shows the INDEXES and does not show the
logicals.
-----Original Message-----
From: smith5646midrange@xxxxxxxxx <smith5646midrange@xxxxxxxxx>
Sent: Wednesday, June 10, 2020 7:15 PM
To: 'Midrange Systems Technical Discussion' <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: RE: DSPDBR via SQL view
Unless something has changed since I looked at that one, it is only VIEWS
and does not report logicals.
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Vernon
Hamberg
Sent: Wednesday, June 10, 2020 7:09 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: DSPDBR via SQL view
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.
--
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@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com
--
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@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com
midrange.com
