ODBC Server Reference Manual

CORE SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
3-53
POWER
POWER
Use POWER to retrieve the value of a numeric expression to a specified power.
The POWER scalar function has the following syntax:
numeric-exp
is a number. It can be the name of a column, the result of another scalar function, or a
numeric literal.
integer-exp
is the power to which the number is raised. It can be the name of a column, the result
of another scalar function, or a numeric literal.
Example
The following SQL statement returns the value 5.2 squared:
select {fn power (5.2,2) }
from tab1
REVOKE
The NonStop ODBC Server recognizes the syntax of the REVOKE statement, but does
not perform its activities.
The REVOKE statement has the following syntax:
The setting of the SQL_UNSUPPORTED flag in the ZNSPROF mapping table
determines whether the NonStop ODBC Server reports an error, issues a warning
message, or ignores the REVOKE statement.
POWER (numeric-exp, integer-exp)
REVOKE { ALL }
{ grant-privilege [‚ grant-privilege ] ...) }
ON table-name
FROM { PUBLIC }
{ user-name [‚ user-name ] ... }
[ CASCADE | RESTRICT ]