SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Functions and Expressions
HP NonStop SQL/MX Reference Manual—540440-003
9-165
USER Function
•
Suppose that your database includes two department tables: DEPT1 and DEPT2.
Return all rows from the two tables in which the department names have the same
value regardless of case:
SELECT * FROM persnl.dept1 D1, persnl.dept2 D2
WHERE UPSHIFT(D1.deptname) = UPSHIFT(D2.deptname);
USER Function
The USER function returns the current Guardian user ID as variable-length character
data in the form group.name.
The USER function is equivalent to the CURRENT_USER Function on page 9-37 and
the SESSION_USER Function on page 9-139.
Examples of USER
•
Retrieve the user name value for the current user:
SELECT USER FROM logfile;
(EXPR)
------------------------------------------
DCS.TSHAW
...
--- 5 row(s) selected.
USER