http://developer.mimer.com

String Pseudo-Literals

---

The following sections document string pseudo-literals.

CURRENT_USER

Returns 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

Syntax for the CURRENT_USER function:

Rule

• 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

Example

 CREATE DOMAIN NAME AS CHAR(128)
 DEFAULT CURRENT_USER;

SESSION_USER

Returns the name of the currently connected ident.

Syntax

Syntax for the SESSION_USER function:

Rule

• The result is the name of the current ident (i.e. the ident who established the current database connection).

Example

The following example returns the Program ident if entered, otherwise the session ident:

 SET CHR_STR = COALESCE(CURRENT_PROGRAM(), SESSION_USER);

USER

Returns the same value as CURRENT_USER. We recommend that you use CURRENT_USER, see CURRENT_USER.

Standard Compliance

This section summarizes standard compliance for scalar functions.

Standard	Compliance	Comments
X/Open-95 SQL-92	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 dbtechnology@upright.se