Re: Trigger Information

at home not at work, i did a q&D select on the table and see a lot I
recognize but there are some where the program name is surrounded by "  i.e.
"Namechg"  in my notmal pgm library and IIRC I looked at the attribute and
it was CLE, I have no clue right now where the source for this might be or
even what type it is (C?  CL-ILE?) let alone what they are
doing..............


On 7/17/06, Dave Odom <Dave.Odom@xxxxxxxxxxxx> wrote:

Dave Smith, et al,

Yes, there is a TABLE... "QSYS2"/"SYSTRIGGER".   Therefore, is there
any reason why you couldn't do things the SQL/DB2 way... use a SELECT
statement and then an UPDATE or just an UPDATE?    I think you are
looking for columns:  A.OPERATIVE, A.ENABLED.

BTW, the query for the full table looks like (some columns have been
cut off):

SELECT
-- Columns
      A.TRIGGER_SCHEMA, A.TRIGGER_NAME, A.EVENT_MANIPULATION,
      A.EVENT_OBJECT_SCHEMA, A.EVENT_OBJECT_TABLE, A.ACTION_ORDER,
      A.ACTION_CONDITION, A.ACTION_STATEMENT, A.ACTION_ORIENTATION,
      A.ACTION_TIMING, A.TRIGGER_MODE, A.ACTION_REFERENCE_OLD_ROW,
      A.ACTION_REFERENCE_NEW_ROW, A.ACTION_REFERENCE_OLD_TABLE,
      A.ACTION_REFERENCE_NEW_TABLE, A.SQL_PATH, A.CREATED,
      A.TRIGGER_PROGRAM_NAME, A.TRIGGER_PROGRAM_LIBRARY, A.OPERATIVE,
     , A.THREADSAFE, A.MULTITHREADED_JOB_ACTION, A.ALLOW_REPEATED_CHAN
      A.TRIGGER_UPDATE_CONDITION, A.LONG_COMMENT
-- Tables
      FROM "QSYS2"/"SYSTRIGGER" A

Dave
--
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.