APPX Software Library

Chapter 4: SQL Language Elements

4.9.2.60 POWER function (ODBC compatible)

Syntax

POWER ( expression1 , expression2 )

Description

The scalar function POWER returns expression1 raised to the power of expression2.

Example

SELECT POWER ( 3 , 2) '3 raised to the 2nd power'
     FROM SYSTPE.SYSCALCTABLE;

Notes

  • expression1 must evaluate to a numeric data type.
  • expression2 must evaluate to an exact numeric data type.