RATE THIS ANSWER
0
Click to Vote:
- 0
0
Hello,
I am not sure what you mean by "visual format."
I will take a guess that you want a floating point number to be returned to your application as a decimal number. Use the DECIMAL function.
For example:
CREATE TABLE TTEST (F_COL FLOAT);
---------+---------+---------+---------+---------+---------+-----
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0
INSERT INTO TTEST VALUES (7.500);
---------+---------+---------+---------+---------+---------+-----
DSNE615I NUMBER OF ROWS AFFECTED IS 1
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0
SELECT F_COL , DEC(F_COL,5,3)
FROM TTEST;
---------+---------+---------+---------+---------+---------+-----
F_COL
---------+---------+---------+---------+---------+---------+-----
+0.7500000000000000E+01 7.500
DSNE610I NUMBER OF ROWS DISPLAYED IS 1
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 100
DROP TABLE TTEST;
Last Answered:
Nov 17 2009 6:42 PM GMT by Meandyou 
2645 pts.
