Re: LF in different library

[Glenn Gundermann <glenn.gundermann@xxxxxxxxx>]

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