Home

Getting Started

Utilities

Indexing

Omnidex

Development

Tutorials

Quick Links

 

SQL Reference

Functions

Syntax

Example

 

SQL Reference

Joins

Nested Queries

Set Operations

ON CURSOR | INSTANCE

WITH Options

Commands

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 data type is a C STRING maximum length 32.

These functions are identical.

 

Syntax

USER

CURRENT_USER

SESSION_USER

 

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