Re: Username for this session

Yep, just use the identifier USER in your select statement. I'm not sure what happens if your table actually has a column named user. i.e. SELECT USER, colA, colB, ... FROM table WHERE ... -Bill > > Hello, > > I am involved in a LiveWirePro application with OWS 7.12TC5. In a > particular Insert statement, one of the fields is the name of the user > who is currently performing the Insert operation. Is there a variable > in Informix like Oracle has "userid" which holds this value and can be > used directly in the Insert ? If yes, what is the variable ? If no, how > else could I insert the name of the current session userid into my table > ? > > Thanks in advance, > Vinitha > > -- Bill Ennis Voice: 312-474-7516 SSA Fax: 312-474-7460 500 W. Madison email: ennis@ssax.com ennis@accesschicago.net