× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



This still uses QABDFDEP, and not everyone is authorized to use this. Now if the QADBLDEP LF that Mark cited has all the columns of QADBFDEP, then that can be substituted in Simon's examples.

Regards
Vern

On 6/11/2020 6:53 AM, Mayer, Michael via MIDRANGE-L wrote:
-----Original Message-----
From: Mayer, Michael
Sent: Tuesday, June 9, 2020 10:53 AM
To: midrange-l@xxxxxxxxxxxxxxxxxx
Subject: RE: DSPDBR via SQL view


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.


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.