RE: Where to place trigger programs?

|-----Original Message-----
|From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-
|bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
|Sent: Friday, February 17, 2006 2:48 PM
|To: Midrange Systems Technical Discussion
|Subject: RE: Where to place trigger programs?
|
|That's not what I am seeing
|
|DSPFFD ROB/AAAKEY
|Trigger Description
|  Trigger name  . . . . . . . . . . . . . . . : TRG QSYS_TRIG_ROB____
|        ____AAAKEY_____000001
|    Trigger library . . . . . . . . . . . . . :            ROB
|    Trigger state . . . . . . . . . . . . . . : STATE      *ENABLED
|    Trigger status  . . . . . . . . . . . . . :            *OPERATIVE
|    Trigger event . . . . . . . . . . . . . . : TRGEVENT   *INSERT
|    Trigger time  . . . . . . . . . . . . . . : TRGTIME    *BEFORE
|    Allow repeated change . . . . . . . . . . : ALWREPCHG  *YES
|    Program Name  . . . . . . . . . . . . . . : PGM        AAAKEYTRG
|      Library . . . . . . . . . . . . . . . . :            ROBTRIG
|    Program is threadsafe . . . . . . . . . . : THDSAFE    *UNKNOWN
|    Multithreaded job action  . . . . . . . . : MLTTHDACN  *SYSVAL
|    Trigger type  . . . . . . . . . . . . . . :            *SYS
|    Trigger orientation . . . . . . . . . . . :            *ROW
|    Trigger creation date and time  . . . . . :            02/17/06
|14:36:11
|    Number of trigger update columns  . . . . :                0
|
|dspobjd aaakey *file
|Object AAAKEY in *LIBL type *FILE not found.
|
|dspobjd aaakeytrg *pgm
|Object AAAKEYTRG in *LIBL type *PGM not found.
|
|dsplibl
|Library     Type
|QSYS        SYS
|QSYS2       SYS
|QHLPSYS     SYS
|QUSRSYS     SYS
|QGPL        CUR
|QTEMP       USR
|QGPL        USR
|
|strsql
|INSERT INTO ROB/AAAKEY VALUES('tx', 1, 't', 't', 't', 't')
|and the trigger fires.
|
|
|Rob Berendt
|--

OK, I tried it again, and the trigger did fire, only this time I had a
really stripped down library list like yours, so the trigger program
threw an error when it didn't find the files it needed to open.  

Before, I didn't have the libraries of the file or the trigger program
(both of which were in our Q/A environment) in my lib list, but I did
have our production libraries in the list, which had all the files
necessary for the trigger program to open.  So the trigger fired, but
failed to find a matching record in the production file, so nothing got
changed in either environment, and I assumed the trigger had not fired.


It's Friday.  Apologies to Walden if I freaked him out, and thanks to
Rob for taking the time to set me straight.  A pox on whoever the OP was
that got me started playing with this in the first place (just kidding).


G