Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site

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

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

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
Mimer SQL Documentation TOC PREV NEXT INDEX