The following sections document string pseudo-literals.
CURRENT_USERReturns the name of the currently connected USER or OS_USER ident or the PROGRAM ident that is currently entered.When used in a routine or trigger, it returns the name of the creator of the schema to which the routine or trigger belongs.
Syntax for the CURRENT_USER function:
- When used in a routine or trigger, the result is the name of the creator of the schema to which the routine or trigger belongs, otherwise the value is the name of the connected ident or the program that was entered
ExampleCREATE DOMAIN NAME AS CHAR(128) DEFAULT CURRENT_USER;
SESSION_USERReturns the name of the currently connected ident.
Syntax for the SESSION_USER function:
- The result is the name of the current ident (i.e. the ident who established the current database connection).
The following example returns the Program ident if entered, otherwise the session ident:SET CHR_STR = COALESCE(CURRENT_PROGRAM(), SESSION_USER);
USERReturns the same value as CURRENT_USER. We recommend that you use CURRENT_USER, see CURRENT_USER.
This section summarizes standard compliance for scalar functions.
EXTENDED Support for the ABS, ASCII_CHAR, ASCII_CODE, CURRENT_VALUE, DAYOFWEEK, DAYOFYEAR, IRAND, MOD, NEXT_VALUE, PASTE, REPEAT, REPLACE, ROUND, SIGN, SOUNDEX, TAIL, TRUNCATE and WEEK functions is a Mimer SQL extension.
Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40