UNIX commands in Perform, not spelling in HK

> Hi all! > > I am having some problems with users not inputting data correctly, > and I would like to know who has input each row. I was hoping that I > would be able to do this in perform, using something like: > > before add of "table name" let id = `whoami` > > If this was possible, it would put the user's unix id into a column, > and I would immediately be able to track down any problems. Is there > any way I can do this, bearing in mind I only have access to I-SQL > v 4.10, an SE engine, SunOS 4.something and I don't do C !! > > TIA, > > Richard. [....sig deleted...] There are at least two solutions to your problem. See the function to get the value of an environmental variable, FGL_GETENV(), on pg 4-58 of my newer manual "Informix 4GL, Volume 2" v6.0, April 1994. Also see the USER function, detailed on pg 3-80 of the "Informix 4GL Ref Manual", v4.0, March 1990. The v6.0 manual also talks about the USER function on page 3-328, but it says to see the older (4.1) manual for a complete discussion. This is also in the "Informix SQL Reference Manual", v4.0 pg 2-51. That should get you started. BTW, isn't it nice to see a post that isn't about that damned HK spelling thing? OH NO, now I'm guilty, too! __________________________________________________________________ | Clem Akins Standard Disclaimers Apply | |Reynolds Metals Co, Alloys Plant "Climb High, Cave Deep!" | | Muscle Shoals, Alabama USA cwakins@leia.alloys.rmc.com | |________________________________________________________________|