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