Re: LF in different library

Does this work for you?

SELECT *
FROM sysviewdep
WHERE object_schema = 'pf-schema-name' AND view_schema <>
'pf-schema-name' ;


Yours truly,

Glenn Gundermann
Email: glenn.gundermann@xxxxxxxxx
Work: (905) 486-1162 x 239
Cell: (416) 317-3144


On 28 March 2018 at 15:32, T. Adair <tadair@xxxxxxxxxxxxxxxx> wrote:

Several years ago, I had a command that I would use to find PF vs. LF
library mismatches. I would give it a library name and, depending on the
other parms, it would show me either...:

PFs in that library that had LFs in other libraries.
- or -
LFs in that library that had their PFs in other libraries.

It may have been a system command, or it could've been a user-written
utility. I really don't remember (old age, and all that). Whatever it is
(or was), I can't seem to locate any info on it. I suppose it could've
been a TAATOOL.

Is this ringing a bell with anyone else?

Thanks.

~TA~

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD