Re: Library List of a Trigger Program

No. People commonly make this error. They make a trigger program and
assume the only updates to the table are coming from their ERP package
from some 5250 or batch program. That program normally feeds down from
some initial program which sets up the library list and what not. Some
even go so far as to assume that all updates occur from some interactive
program and they send out a display message. So, they test it using only
this idealized condition. Then the first time someone updates the file
using Excel or iNav's Run Sql Scripts all heck breaks loose. What you
could do is read the parameters of the trigger program. If the parameter
which tells you what schema the table is in says TESTLIB then hopefully
your application has either a job description or data area in that schema
that it can read to set the library list.

Granted, 10,000 trigger actions each preceeded by computing and setting
the library list can be a small drag on performance. So, someone will
tell you to put all trigger actions on to a data queue. So, you still
have to read the schema parameter on the trigger program to make sure you
put the entry on the right data queue.


Rob Berendt