Re: Get PF for LF

SELECT TABLE_SCHEMA,
TABLE_NAME,
TABLE_PARTITION
FROM QSYS2.SYSPARTITIONINDEXES
WHERE INDEX_SCHEMA = 'MYLIB'
AND INDEX_NAME = 'MYLFNAME'
AND INDEX_TYPE = 'LOGICAL';

or:

WITH based_json AS (
SELECT BASED_ON_FILES
FROM QSYS2.SYSFILES
WHERE SYSTEM_TABLE_SCHEMA = 'MYLIB'
AND SYSTEM_TABLE_NAME = 'MYLFNAME'
)
SELECT U.*
FROM based_json,
JSON_TABLE(
based_json.based_on_files,
'lax $.BASED_ON_FILES'
COLUMNS(
"LIBRARY" VARCHAR(10), "FILE" VARCHAR(10), "MEMBER"
VARCHAR(10),
"LF_FORMAT" VARCHAR(10)
)
) AS U;

HTH
--
Marco Facchinetti

Mr S.r.l.

Tel. 035 962885
Cel. 393 9620498

Skype: facchinettimarco


Il giorno ven 29 dic 2023 alle ore 19:36 Rob Berendt <
robertowenberendt@xxxxxxxxx> ha scritto:

You're right *PUBLIC can read the data in the QADB* files but they cannot
'operate' on them. Therefore they cannot access them directly, even to
read them. They have to use a view they have operational access to.

On Fri, Dec 29, 2023 at 1:14 PM VERNON HAMBERG Owner via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx> wrote:

Referring to your and Roger's replies (SYSFILES BTW doesn't have the
Based-on JSON), not sure of 7.4, 7.5 does)


The QADB* cross-reference files are often restricted - I know I can't do
anything with them. The SYS* views are based on them, but those views

have

authority given by IBM.

I'm going to look at Brad's tool - meanwhile, DSPFD is easy and clean
enough, for now, methinks.


Cheers and Happy New Year, y'all!


Vern


On Fri, 29 Dec, 2023 at 11:45 AM, Rob Berendt <

robertowenberendt@xxxxxxxxx>

wrote:


To: midrange systems technical discussion

Slightly more raw:
QADBFDEP QSYS PF Cross reference dependency file

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx<mailto:
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<mailto:
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<mailto:
support@xxxxxxxxxxxxxxxxxxxx> for any subscription related questions.

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

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