Re: Access to UNIX environment variables in ISQL

in isql you should be able to do something like: select unique user from systables; This will return the login of the user running the isql session. you don't have to select from systables... you can select from any valid table. You could use the above select as part of an update statement to set a column value. HTH, -robw On Thu, 16 Jan 1997 22:31:52 GMT, kcj@coolabah.com (Kate Juliff) wrote: >I'd like to be able to access LOGNAME from ISQL and do not know how I >can do this simply. Is there a way? (I'm running Informix under SCO >3.2) > >I'd really like to put the user's name in a table and I can do this >from ESQL if necessary but i'd prefer some simple way. Any pointers? > >Kate >