SQL Functions

USER | CURRENT_USER | SESSION_USER

The USER, CURRENT_USER, SESSION_USER functions return the current user of Omnidex as entered when first connected to the current open environment. If no user was entered, the user of "DEFAULT" is returned. The return datatype is a C STRING maximum length 32.

These functions are identical.

Syntax

USER

CURRENT_USER

SESSION_USER

top

Example

select company, user from customers where company='dynamic'

Dynamic Information Systems Corporation, DEFAULT

...

select company, current_user from customers where company='dynamic'

Dynamic Information Systems Corporation, DEFAULT

...

select company, session_user from customers where company='dynamic'

Dynamic Information Systems Corporation, DEFAULT

top