Formatting a number

[Guest_imported]

Hi,
I am new to db2. I have been using oracle all these time. We have a project which involves db2. I need to know if there is any function which can format a number in a given format (similar to to_char(10000,"999,999.00&quot in oracle which will give me 10,000.00 as output) in DB2.
Can anyone help me. I would be greatful for the same.
thanks and regards,
V.bhaskar.

 

[blom0344]

Hi visitor,

Use the DEC function:

DEC(number,precision,scale) output is decimal

or the CHAR function:

CHAR(number) output depends on input type, but is always a char. T. Blom
Information analist
Shimano Europe
tbl@shimano-eu.com

 

[ParthaMahapatra]

I would recommend using the FLOAT function instead of the DEC function. The DEC function does some rounding and you may lose the numbers after the decimal point.

You can then format using the forms if you are using QMF.