RE: Get PF for LF

Dspfld on logical.

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of VERNON HAMBERG Owner via MIDRANGE-L
Sent: Friday, December 29, 2023 2:09 PM
To: midrange-l@xxxxxxxxxxxxxxxxxx
Cc: VERNON HAMBERG Owner <vhamberg@xxxxxxxxxxxxxxx>; midrange-l@xxxxxxxxxxxxxxxxxx
Subject: Re: Get PF for LF

Caution: This is an external email. Please take care when clicking links or opening attachments. When in doubt, contact your IT Department



Hi Justin


The QADB* PFs and LFs are severely restricted - IBM do not want them accidentally corrupted. If you are able to work with them, you would seem to have some elevated level of authority to them. I think it is strongly advised not to use them in programs that regular users will be running

The JSON in the recent SYSFILES can be used nicely by using the JSON_TABLE function, I would think. But if you are on pre-7.5 release, I recommend the DSPFD thing - it's been around forever, safe, reliable. And you can't trust that IBM won't put tighter reins on these "system" files.


The reason I know is related to a tool I once wrote that used the QADB* files and failed when lower authority levels tried to run things.


Cheers
Vern


On Fri, 29 Dec, 2023 at 1:13 PM, Justin Taylor <jtaylor.0ab@xxxxxxxxx> wrote:


To: midrange-l

Both QSYS2.SYSFILES and QSYS.QADBLDEP give the answer, but SYSFILES returns it as JSON. I prefer not to parse JSON if I don't have to.

Thanks guys!
--
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.