Information icon IBM InfoSphere DataStage and InfoSphere QualityStage, Version 8.5
space Feedback

Pwr Function

Raises the value of a number to the specified power.

Syntax

Pwr (number, power)

number is an expression evaluating to the number to be raised to power. If number is a null value, null is returned.

power specifies the power to raise number to. If power is a null value, null is returned. If power is not an integer, number must not be negative.

Remarks

On overflow or underflow, a warning is printed and 0 is returned.

Example

This is an example of the use of the Pwr function:

OppSide = Sqrt(Pwr(Side1, 2) + Pwr(Side2, 2))

PDFThis topic is also in the IBM InfoSphere DataStage Server Job Developer's Guide.

Update timestamp Last updated: 2010-09-30