SIGN

Restriction: This topic applies to Windows environments only.

ANSI	DB2	SQL/DS	XDB
			X

Returns the sign of the parameter expr. The format appears below:

SIGN(expr)

A value of one is returned if expr is positive, and a value of zero is returned if expr is zero, and -1 is returned if expr is negative. For example:

SIGN(-234.4) = -1
SIGN(234) = 1
SIGN(0) = 0