James,

Try:

SELECT DBXTBTLIB, DBXTBDNAME, DBXTBTNAME, DBXTBENAB FROM QADBXTRIGB
DBXTBENAB shows 'Y' or 'N' for *ENABLED/*DISABLED

This is the PF from where the SYSTRIGGERS view is based.

Regards,

Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries


On Fri, Oct 16, 2009 at 2:21 PM, James H. H. Lampert <
jamesl@xxxxxxxxxxxxxxxxx> wrote:

Bob P. Roche wrote:
At least you don't have to remember all the steps to re apply your
trigger. Is it before or after, update, add, delete or please not a read
trigger. It's useful that way just re-enable

True, but that doesn't help much if you've got about a dozen or more
files involved. Easier to just write a CL program.

More to the point, if the triggers are merely "sleeping," then only a
DSPFD will tell you why they're not getting invoked (and I can't tell
you what gave me the impulse to try a DSPFD, either, beyond grasping at
straws). Nothing shows up in a PRTTRGPGM to indicate that they're
disabled. Sounds like a very easy way to send your IT staff on a one-way
trip to the rubber room.

--
JHHL
--
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: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.



This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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