Hi all,
I have a field AMOUNT(Decimal 13,2) and when I check the length its
coming as 7.
AMOUNT LENGTH
15.00 7
118.00 7
0.00 7
10.00 7
I need to format theAMOUNT field so that when I do a length of it I
should get 14(this includes a decimal)
Example
AMOUNT LENGTH
12345678911.58 14
if the amount is 15.00 I have to LPAD appropriate spaces so that when i
do lengthg of the amount it should come like ' 15.00' ...
I tried doing
RIGHT(' .00'||RTRIM(char(dec(AMOUNT,13,2))),14)
but I am getting like 00000000015.00 and I have 5 other amount fields
and when I use it in SQL getting SQL1585N A system temporary table
space with sufficient page
size does not exist. SQLSTATE=54048
please advice me.....