SQL Reference

POWER

>>-POWER--(--expression1--,--expression2--)--------------------><
 

The schema is SYSFUN.

Returns the value of expression1 to the power of expression2.

The arguments can be of any built-in numeric data type. DECIMAL and REAL arguments are converted to double-precision floating-point number.

The result of the function is:

• INTEGER if both arguments are INTEGER or SMALLINT

• BIGINT if one argument is BIGINT and the other argument is BIGINT, INTEGER or SMALLINT

• DOUBLE otherwise.

The result can be null; if any argument is null, the result is the null value.

[ DB2 List of Books | Search the DB2 Books ]