Hello,
We are trying to setup an update notification on a DB2 table/file on our AS/400.
My question, when we enable the integration component, will it add to an existing update trigger on the file or overwrite the file?
Please HELP !!!
Currently DB2 only allows for 6 triggers. One for each event Before/After on Update/Delete/Insert events.
If you have a trigger and you wish to add another for the same event you will most likely have to re-program the trigger code to include the logic for both triggers. You can then recompile the trigger. Of course you will have to use Basic Notification and that means creating the shadow tables manually. The whole process is fairly simple.
Hope this helps.
CD