Hello, i am implementing a trigger on a table that will capture the audit information on that table (who inserted, updated, deleted).
I am going to use SQL Create Trigger. In my audit file i need the program name that did the actual update, job name etc. How should the SQL trigger capture the actual program that updated the base file?
Example - Base File is say F55BASE that has the trigger. Say a program called P55PGM updates a row in F55BASE, the SQL trigger should capture P55PGM as teh program name that updated the file.