Re: Access to UNIX environment variables in ISQL

robw@datapac.com (Rob Weight) wrote: :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. You don't need to use such a select in an update statement. user is a built in function that works in select, update and insert statements. Also instead of select unique ... a select from a table with only one row or an appropriate where clause would be faster. :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 :> Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org