DECFLOAT

The DECFLOAT function returns a decimal floating-point representation of a number or a string representation of a number.

Example:

Use the DECFLOAT function in order to force a DECFLOAT data type to be returned in a select-list for the EDLEVEL column (data type = SMALLINT) in the EMPLOYEE table. The EMPNO column should also appear in the select list.

SELECT EMPNO, DECFLOAT(EDLEVEL,16) 
FROM EMPLOYEE