getting directory passed to trigger?
Posted in 1996
I have a table stilocar, whenever there is an insert/update/delete, a trigger inserts into stilocara. stilocara is the same as stilocar, except for the addition of 3 fields, event, user_id, timestamp. These are set to I/U/D, user, current. This works fine! BUT, i want to add progid to stilocara and have the trigger insert the triggering program in it. This can be full path (/usr/fourgen/accounting/oe.4gm/i_pack.bpt) OR a variable in the triggering program (progid is set to oe.i_pack) OR the output of fgl_getenv("PWD") which will be the full path OR the output of system("pwd") (Stored Procedure) which will also be the full path. Anything that works, I don't care. As long I don't have to edit any/all of the dozens of programs that hit stilocar. Stored procedures are fine too. $INFORMIXDIR/lib/sqlturbo -V = 5.05.UC3 Any ideas? Thanks, Scott ================================================================== Scott Rubin, FourGen Software (Client Services) scottr@fourgen.com