SIGN

Returns an indicator of the sign of expression. The returned value is:

The argument is an expression that returns a value of any built-in numeric data type.

Example:

Assume column PROFIT has a value of 50000.

  SELECT SIGN(PROFIT)
    FROM CORPDATA.EMPLOYEE

This example returns the value 1.