× 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.



DSPDBR QADBFDEP?

Otherwise there may be an infinite recursion problem.

-----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.



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.


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
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.