POWER

POWER raises the left argument (base) to the power of the right argument (exponent):

Integer POWER( base Integer, exponent Integer )

Decimal POWER( base Decimal, exponent Integer )

Double POWER( base Double, exponent Integer )

Example

The following code:

SELECT CUSTOMERS.CUSTID, POWER(CUSTOMERS.CUSTID, 2)

FROM "../Data Sources/MyDatabase/CUSTOMERS.SMA" CUSTOMERS

returns:

101,10201

102,10404

104,10816

…

For decimal data types, the result’s precision and scale are (P, s), where P is the maximum precision in the database or the Integration service, and s is the scale of the operand.

Copyright Actuate Corporation 2012