With the RELATED_OBJECTS Table function in the SYSTOOLS schema, you'll get a
list of all dependend Objects:
Select *
from Table(Systools.Related_Objects(Library_Name => 'YOURLIB',
File_Name => 'YOURPF'));
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
Modernization ? Education ? Consulting on IBM i
Database and Software Architect
IBM Champion since 2020
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
"Train people well enough so they can leave, treat them well enough so they
don't want to. " (Richard Branson)
"Learning is experience ? everything else is only information!" (Albert
Einstein)
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
smith5646midrange@xxxxxxxxx
Sent: Wednesday, 19 June 2024 19:46
To: 'Midrange Systems Technical Discussion' <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Things that would prevent the deletion of a PF
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.
midrange.com
