Re: Things that would prevent the deletion of a PF

How about the system catalog? Lots of SQL examples in its use. See examples in the ACS.


Jim Oberholtzer
Agile Technology Architects

On Jun 19, 2024, at 1:54 PM, smith5646midrange@xxxxxxxxx wrote:

Sorry I was not clear. My program will be deleting the PFs and it will adopt *ALLOBJ so security is not an issue. I am primarily concerned with things "linked" to the PF.


-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Javier Sanchez
Sent: Wednesday, June 19, 2024 2:47 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: Things that would prevent the deletion of a PF

Right at this moment all I can think of is Security. If they are key business PF's protect them with *PUBLIC *EXCLUDE and grant authority only to some users and also use adopted authority in programs. There may be another way though.

El mié, 19 jun 2024 a las 11:46, <smith5646midrange@xxxxxxxxx> escribió:
I need to programmatically find everything that would prevent the
deletion of a PF such as LFs, indexes, etc. Is there a table or
function that I can look at to find this information? I don't want to
do a DSPDBR to an outfile, Are there other things that will prevent
the deletion of the PF that I am not thinking of and where do I look
for them to determine if they exist (again looking for a table or function not a command to an outfile).
I'm not worried about object locks. These will all be obsolete PFs
and if someone has a lock on it, it needs to fail.
--
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.


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