i tried, and the length become from 11 to 5, but the actual field
armo12 in table arpmbal is 2.

Serge Rielau wrote:
> db2group88 wrote:
> > so you do rtrim(COALESCE(ML101PD.ARPMBAL.ARMO12, 0))?
> CAST the 0 to the type of ML101PD.ARPMBAL.ARMO12. That should do it.
> COALESCE(ML101PD.ARPMBAL.ARMO12, CAST(0 AS <..>))
>
> --
> Serge Rielau
> DB2 Solutions Development
> IBM Toronto Lab
>
> WAIUG Conference
> http://www.iiug.org/waiug/present/Fo...Forum2006.html