RE: DSPDBR via SQL view -- MIDRANGE-L

Good morning everyone.
Please try this link. Simon Hutchinson always has excellent SQL examples in his daily emails.

https://www.rpgpgm.com/2019/10/getting-database-relationships-using-sql.html

Very Respectfully,
Michael Mayer
IBM i Support / System Admin.
IT Operations.
The Florida Bar
651 E. Jefferson St
Tallahassee, Florida 32399-2300
mailto:mmayer@xxxxxxxxxxxxxx
https://www.floridabar.org
Office: 850.561.5761
Cell: 518.641.8906

---------------------------------------------------------

Today's Topics:

1. RE: DSPDBR via SQL view (Kevin Wright)

----------------------------------------------------------------------

message: 1
date: Tue, 9 Jun 2020 12:54:47 +1000
from: Kevin Wright <mailto:kevin.wright@xxxxxxxxxxxx>
subject: RE: DSPDBR via SQL view

So either read up on what views are available at your OS version, or use DSPDBR on the table / physical file qadbfdep to see if there are any views (which you should be authorised to), that you can use your SQL query on.

-----Original Message-----
From: MIDRANGE-L <mailto:midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of mailto:smith5646midrange@xxxxxxxxx
Sent: Tuesday, 9 June 2020 12:26 PM
To: 'Midrange Systems Technical Discussion'
<mailto:midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: RE: DSPDBR via SQL view

I was referring to using it in an sql statement as in

select * from qadbfdep

-----Original Message-----
From: MIDRANGE-L <mailto:midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Kevin Wright
Sent: Monday, June 8, 2020 10:23 PM
To: Midrange Systems Technical Discussion <mailto:midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: RE: DSPDBR via SQL view

DSPDBR QADBFDEP?

Otherwise there may be an infinite recursion problem.

-----Original Message-----
From: MIDRANGE-L <mailto:midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of mailto:smith5646midrange@xxxxxxxxx
Sent: Tuesday, 9 June 2020 12:19 PM
To: 'Midrange Systems Technical Discussion'
<mailto: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.

On a somewhat related subject, is there any "command to view" cross reference documentation anywhere? For example: DSPFD *MBRLSIT = SYSPARTITIONSTAT. It is hard to find which view you need to use when you don't know the name of it. If you know the command, this would point you to the correct view or views.

________________________________
Please note: Florida has very broad public records laws. Many written communications to or from The Florida Bar regarding Bar business may be considered public records, which must be made available to anyone upon request. Your e-mail communications may therefore be subject to public disclosure.