INTEGER

Restriction: This topic applies to Windows environments only.

ANSI	DB2	SQL/DS	XDB
	X		X

Converts a number into an integer value, in the same way that the value would be converted if assigned to an INTEGER field. The format appears below:

INTEGER(x)

In DB2 compatibility mode, the parameter x cannot be a string. In XDB mode, x can be a string.