CURRENT_USER SQL Function
Syntax
CURRENT_USER
Description
CURRENT_USER returns a character string identifier for the database user as specified in the current connection. It returns a character in the database character set. If the current connection did not specify an user, CURRENT_USER returns the login name as determined by the host operating system.
FairCom DB SQL statements can refer to CURRENT_USER anywhere they can refer to a character string expression.
Example
ISQL>SELECT CURRENT_USER FROM admin.syscalctable ;
FRED
---------------
fred
1 record selected
Note: SQL-99 compatible