Neoview SQL Reference Manual (R2.4 SP2)

CURRENT_USER Function
The CURRENT_USER function returns the user name that you logged in as. If you are logged
in as the role, the role is returned. This function can be used anywhere in the query. The values
returned are string datatype VARCHAR(64).
CURRENT_USER
The CURRENT_USER function is equivalent to the “USER Function” (page 472).
Considerations for CURRENT_USER
The CURRENT_USER function returns the user name in ISO8859-1 encoding on a Neoview
platform that has the ISO88591 or SJIS configuration. It returns the user name in UCS2 encoding
on a Neoview platform that has the Unicode configuration. For more information on the Neoview
character set configurations, see the Neoview Character Sets Administrator's Guide.
Example of CURRENT_USER
This example retrieves the user name value for the current user:
SELECT CURRENT_USER FROM logfile;
(EXPR)
-----------------------
DCS.TSHAW
...
--- 5 row(s) selected.
366 SQL Functions and Expressions