Re: Search for files with a given trigger program? -- MIDRANGE-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

Subject: Re: Search for files with a given trigger program?
From: Mark Waterbury <mark.s.waterbury@xxxxxxxxxxxxx>
Date: Wed, 13 Feb 2019 17:45:44 +0000 (UTC)
List-archive: <https://archive.midrange.com/midrange-l/>
List-help: <mailto:midrange-l-request@lists.midrange.com?subject=help>
List-id: Midrange Systems Technical Discussion <midrange-l.lists.midrange.com>
List-post: <mailto:midrange-l@lists.midrange.com>
List-subscribe: <https://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@lists.midrange.com?subject=subscribe>
List-unsubscribe: <https://lists.midrange.com/mailman/options/midrange-l>, <mailto:midrange-l-request@lists.midrange.com?subject=unsubscribe>

James,
I thought there may be a new IBM i Db2 service for this, but was not able to find one for that, and, you may need to do this on a version/release before such services were available...

So for now you could issue:
    DSPFD FILE(library1/*ALL) TYPE(*TRG) OUTPUT(*OUTFILE) FILEATR(*PF) +            OUTFILE(QTEMP/TRIGGERINF) OUTMBR(*FIRST *REPLACE)

    DSPFD FILE(library2/*ALL) TYPE(*TRG) OUTPUT(*OUTFILE) FILEATR(*PF) +            OUTFILE(QTEMP/TRIGGERINF) OUTMBR(*FIRST *ADD)

    DSPFD FILE(library3/*ALL) TYPE(*TRG) OUTPUT(*OUTFILE) FILEATR(*PF) +            OUTFILE(QTEMP/TRIGGERINF) OUTMBR(*FIRST *ADD)
    etc.

and then query or examine the results in that TRIGGERINF table.
HTH,
Mark S. Waterbury

On Wednesday, February 13, 2019, 12:05:06 PM EST, James H. H. Lampert <jamesl@xxxxxxxxxxxxxxxxx> wrote:

Is there a way (short of going through every single PF on the system) to
list all the files that hava a particular trigger program?

--
JHHL

As an Amazon Associate we earn from qualifying purchases.

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