Tweet
I need to show negative decimal values with a leading zero in SQL + xmlrow ()
It means value DEC(3,2) = -0,12 as -0,12.
iSeries SQL produces: -,12 or -.12 depending on the decimal separator format.
Questions.
Is there any global SQL solution to set the number format presented?
Can we set the format of the presented number using xmlserialize / xmlrow?
I have a lot of built-in SQL, and I don't want to use varchar_format for each sql/field.
It means value DEC(3,2) = -0,12 as -0,12.
iSeries SQL produces: -,12 or -.12 depending on the decimal separator format.
Questions.
Is there any global SQL solution to set the number format presented?
Can we set the format of the presented number using xmlserialize / xmlrow?
I have a lot of built-in SQL, and I don't want to use varchar_format for each sql/field.