Hi *,
imagine physical file with columns NAME, SURNAME, MARITALSTS, WASMARRIED (flag Y/N). Lots of processes update MARTIALSTS in this file and I want to create a trigger that checks if MARITALSTS was set to married. If yes, I want to set flag WASMARRIED to 'Y'. Can I update inside my trigger PGM a record, which is currently processed by this trigger, or I will get some lock?
Real situation is more complicated, example above is only to show what I want to do.
Thanks
imagine physical file with columns NAME, SURNAME, MARITALSTS, WASMARRIED (flag Y/N). Lots of processes update MARTIALSTS in this file and I want to create a trigger that checks if MARITALSTS was set to married. If yes, I want to set flag WASMARRIED to 'Y'. Can I update inside my trigger PGM a record, which is currently processed by this trigger, or I will get some lock?
Real situation is more complicated, example above is only to show what I want to do.
Thanks
Comment