ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

Triggers and trigger programs

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Triggers and trigger programs

    What is the easiest way to get a list of all the files on our system that have triggers along with a list of all trigger programs? I don't know which libraries might contain files with triggers.

  • #2
    DSPFD FILE(*ALL) TYPE(*TRG) OUTPUT(*OUTFILE) OUTFILE(mylib/myfile)

    You may wish to query the output file to omit IBM-supplied files, 3rd party vendors, etc... depending on what you're after.

    Comment


    • #3
      Thanks Scott. That's basically what we were thinking and have been experimenting with. I'm surprised you can do *ALL and was afraid we would have to do each library individually.

      Comment


      • #4
        Have you had a look at the SYSTRIGGERS view in the QSYS2 Library?

        Birgitta

        Comment


        • #5
          I would use PRTTRGPGM (Print Trigger Programs)

          Comment


          • #6
            Thanks Birgitta and Peder. I guess an old guy can still learn something new if you ask the right question, or the right person!

            Comment

            Working...
            X