SQL query to get names of LFs pointing to PFs created in incorrect libraries -- RPG400-L

Subject: SQL query to get names of LFs pointing to PFs created in incorrect libraries
From: pr20251925 <pr20251925@xxxxxxxxx>
Date: Fri, 14 Feb 2025 14:21:10 +0000
List-archive: <https://archive.midrange.com/rpg400-l/>
List-post: <mailto:rpg400-l@lists.midrange.com>
List-subscribe: <https://lists.midrange.com/mailman/listinfo/rpg400-l>, <mailto:rpg400-l-request@lists.midrange.com?subject=subscribe>
List-unsubscribe: <https://lists.midrange.com/mailman/options/rpg400-l>, <mailto:rpg400-l-request@lists.midrange.com?subject=unsubscribe>

Hi,

How to extract all LFs which are created based on PFs(which are in incorrect libraries)

For example LF1 which is there in LIB1 and has been created based on PF1 in Lib2( ideally should have been created in LIB1 only).

So Any SQL query by which detailss of all Such LFs could be extracted?

Thanks...

As an Amazon Associate we earn from qualifying purchases.

Follow-Ups:

RE: SQL query to get names of LFs pointing to PFs created in incorrect libraries , Birgitta Hauser

This mailing list archive is Copyright 1997-2025 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.