SEO

hi ,
I have a column with datatype as decimal(31,2) . The data is like
123456.67 , 7634578.99
Is it a way to convert the entire number into character . like
'1232456.67' .

The output should not be like as below :
db2 => select char(decimal(BAL_PRINCIPAL,31,2)) from
BIKASHK.RPT_BA_PAD331 where
integer(Bal_principal)!=0

1
---------------------------------
00000000000000000000010025000.00
00000000000000000000010025000.00
00000000000000000000010025000.00
00000000000000000000010025000.00

4 record(s) selected.

Rather It should be

10025000.00
10025000.00
10025000.00
10025000.00

For the above 4 rows and it should be 'char' in data type.

Appreciate your help .
Best Regards
Bikash Karan

karanbikash@gmail.com wrote:
> hi ,
> I have a column with datatype as decimal(31,2) . The data is like
> 123456.67 , 7634578.99
> Is it a way to convert the entire number into character . like
> '1232456.67' .
>
> The output should not be like as below :
> db2 => select char(decimal(BAL_PRINCIPAL,31,2)) from
> BIKASHK.RPT_BA_PAD331 where
> integer(Bal_principal)!=0
>
> 1
> ---------------------------------
> 00000000000000000000010025000.00
> 00000000000000000000010025000.00
> 00000000000000000000010025000.00
> 00000000000000000000010025000.00
>
> 4 record(s) selected.
>
> Rather It should be
>
> 10025000.00
> 10025000.00
> 10025000.00
> 10025000.00
>
> For the above 4 rows and it should be 'char' in data type.
Just LTRIM or STRIP the leading 0s



--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

On May 7, 5:34*pm, Serge Rielau <srie...@ca.ibm.com> wrote:
> karanbik...@gmail.com wrote:
> > hi ,
> > I have a column with datatype as decimal(31,2) . The data is like
> > 123456.67 *, 7634578.99
> > Is it a way to convert the entire number into character . like
> > '1232456.67' * * .
>
> > The output should not be like as below :
> > db2 => select char(decimal(BAL_PRINCIPAL,31,2)) from
> > BIKASHK.RPT_BA_PAD331 where
> > *integer(Bal_principal)!=0
>
> > 1
> > ---------------------------------
> > 00000000000000000000010025000.00
> > 00000000000000000000010025000.00
> > 00000000000000000000010025000.00
> > 00000000000000000000010025000.00
>
> > * 4 record(s) selected.
>
> > Rather It should be
>
> > 10025000.00
> > 10025000.00
> > 10025000.00
> > 10025000.00
>
> > For the above 4 rows and it should be 'char' in data type.
>
> Just LTRIM or STRIP the leading 0s
>
> --
> Serge Rielau
> DB2 Solutions Development
> IBM Toronto Lab- Hide quoted text -
>
> - Show quoted text -

Hi Serge ,

Thanks It worked . I did modified it a bit .

Thanks
Regards
Bikash Karan