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


  1.  Home
  2. MIDRANGE-L
  3. January 2024

Re: Get PF for LF

:) Maybe true, Javier. It just seems like the long way around to determine which PF members the LF is based on by using fields, if possible at all - and the original question was about getting a list of the based-on members, right?


Cheers
Vern

On Tue, 2 Jan, 2024 at 3:59 PM, Javier Sanchez <javiersanchezbarquero@xxxxxxxxx> wrote:


To: midrange systems technical discussion

In general, this may work most of the time, because the common practice
when creating LF's is to provide only the PF's record name, so the LF
compiler will include all fields. I work with some LF's where the fields
may be renamed, and moreover, not all of them may be selected, and that is
a valid LF. So in these cases, you may not be successful in retrieving the
whole, original PF layout.

JS


El mar, 2 ene 2024 a las 14:51, VERNON HAMBERG Owner via MIDRANGE-L (<
midrange-l@xxxxxxxxxxxxxxxxxx<mailto:midrange-l@xxxxxxxxxxxxxxxxxx>>) escribió:

Hi Troy


I don't see DSPFLD on a machine I have full authority on. I had
recommended DSPFD below - is that what you meant?


If not, I'm curious to know what DSPFLD is and where it comes from - TAA
Tools, perhaps?

I'm also curious - does the tool you speak of tell you which tables an LF
is based on? DSPFLD sounds like DSPFFD, I also googled for DSPFLD and found
a 30-year-old QMQRY thing, as well as a toolset called Projex4i and some
other stuff - had never heard of Projex4i, anyone know it? Also something
suggested by Nick Litten based on the QADB* tables - I have to give the
same caveat - IBM locks those down pretty well. I just did a little test,
first on a machine where my USRCLS is *SECOFR - I can do anything, of
course. Then on our company system - DSPPFM QADBXREF gave me a not
authorized message. So did trying to take the SQL statement that SYSTABLES
is - over QADBXREF and another QADB* table - and rightfully so.


Many in these lists have elevated authority - be careful about
recommending things you can just do - same challenge if you're a software
developer and test everything with your special profile, not what a
customer will be using.


Regards
Vern


On Tue, 2 Jan, 2024 at 11:27 AM, Troy Foster <tfoster@xxxxxxxxxxxxxxxx<mailto:tfoster@xxxxxxxxxxxxxxxx>>
wrote:


To: midrange systems technical discussion

Dspfld on logical.

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx<mailto:midrange-l-bounces@xxxxxxxxxxxxxxxxxx><mailto:
midrange-l-bounces@xxxxxxxxxxxxxxxxxx<mailto: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<mailto:midrange-l@xxxxxxxxxxxxxxxxxx><mailto:midrange-l@xxxxxxxxxxxxxxxxxx<mailto:midrange-l@xxxxxxxxxxxxxxxxxx>>
Cc: VERNON HAMBERG Owner <vhamberg@xxxxxxxxxxxxxxx<mailto:vhamberg@xxxxxxxxxxxxxxx><mailto:
vhamberg@xxxxxxxxxxxxxxx<mailto:vhamberg@xxxxxxxxxxxxxxx>>>; midrange-l@xxxxxxxxxxxxxxxxxx<mailto:midrange-l@xxxxxxxxxxxxxxxxxx><mailto:
midrange-l@xxxxxxxxxxxxxxxxxx<mailto: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<mailto:jtaylor.0ab@xxxxxxxxx>
<mailto:jtaylor.0ab@xxxxxxxxx<mailto: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><mailto:
MIDRANGE-L@xxxxxxxxxxxxxxxxxx<mailto:MIDRANGE-L@xxxxxxxxxxxxxxxxxx>><mailto:MIDRANGE-L@xxxxxxxxxxxxxxxxxx<mailto:MIDRANGE-L@xxxxxxxxxxxxxxxxxx>
<mailto: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><mailto:
MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx<mailto:MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx>><mailto:
MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx<mailto:MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx><mailto:
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><mailto:
support@xxxxxxxxxxxxxxxxxxxx<mailto:support@xxxxxxxxxxxxxxxxxxxx>><mailto:support@xxxxxxxxxxxxxxxxxxxx<mailto:support@xxxxxxxxxxxxxxxxxxxx><mailto:
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<mailto:MIDRANGE-L@xxxxxxxxxxxxxxxxxx><mailto:
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><mailto:
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><mailto:
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<mailto:MIDRANGE-L@xxxxxxxxxxxxxxxxxx><mailto:
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><mailto:
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><mailto:
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<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.



As an Amazon Associate we earn from qualifying purchases.

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