ODBC Server Reference Manual

Transact-SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
4-24
Functions
SUSER_NAME
The SUSER_NAME function has the following syntax:
server-user-id
is not supported. The NonStop ODBC Server ignores this parameter.
When executed using the NonStop ODBC Server, SUSER_NAME returns the logical
username of the current user. The current user is the user who is logged on.
USER_ID
The USER_ID function has the following syntax:
user-name
is not supported. The NonStop ODBC Server ignores this parameter.
When executed using the NonStop ODBC Server, USER_ID returns an integer that is
the numeric user ID of the current user.
USER_NAME
The USER_NAME function has the following syntax:
user-id
is not supported. The NonStop ODBC Server ignores this parameter.
When executed using the NonStop ODBC Server, USER_NAME returns the logical
username of the current user. The current user is the user who is logged on.
For more information on Transact-SQL system functions, see the Microsoft SQL Server
Transact-SQL Reference.
Conversion Function
The NonStop ODBC Server supports the Transact-SQL conversion function,
CONVERT. The CONVERT function has the following syntax:
SUSER_NAME ( [ server-user-id ] )
USER_ID ( [ user-name ] )
USER_NAME ( [ user-id ] )
CONVERT ( data-type , expression [ , style ] )