ODBC Server Reference Manual

Transact-SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
4-23
Functions
POWER returns the value of numeric-expression-1 raised to the power of
numeric-expression-2. The expressions can be of integer, float, or money type.
The result is of the same data type as numeric-expression-1.
For more information on Transact-SQL mathematical functions, see the Microsoft SQL
Server Transact-SQL Reference.
String Functions
The NonStop ODBC Server supports one Transact-SQL string function:
UPPER returns the value of character-expression, shifted to uppercase
characters.
For more information on Transact-SQL string functions, see the Microsoft SQL Server
Transact-SQL Reference.
System Functions
The NonStop ODBC Server supports the following Transact-SQL system functions:
•
DB_NAME
•
SUSER_NAME
•
USER_ID
•
USER_NAME
All parameters of these functions are ignored.
DB_NAME
The DB_NAME function has the following syntax:
database-id
is not supported. The NonStop ODBC Server ignores this parameter.
When executed using the NonStop ODBC Server, DB_NAME returns the current
database name in the format node_volume_subvolume. The current database is
the database specified on the most recent USE statement. When you log on to the
NonStop ODBC Server, the database name specified for the current user in the
ZNSUS table; if no rows exist in ZNSUS that map to the current logon name, the
master database is used by default.
UPPER ( character-expression )
DB_NAME ( [ database-id ] )