hi all,
i need to convert a decimal field to a char field..
here is the need for that.
i am having a PF named PF01 and FLD1 is one of the field having field attribute of 5P 0. i want to convert the datas stored in the FLD1 of PF01 to the table TAB01 which is having a field FLD2 with attribute of char 10 not null with default.
-------------------------------------------------
PF's Desired o/p of o/p of
DATA Output using using
(5P 0) CHAR 7 DIGITS CHAR
-------------------------------------------------
-100.00 -100.00 10000 -100.00
100.00 100.00 10000 100.00*
20.00 020.00 02000 20.00**
3.00 003.00 00300 3.00***
0.40 000.40 00040 .40****
0.05 000.05 00005 .50****
---------------------------------------------------
where * indicates blanks.
is there is any way simple way to get the desired output?
thanks in advance..
i need to convert a decimal field to a char field..
here is the need for that.
i am having a PF named PF01 and FLD1 is one of the field having field attribute of 5P 0. i want to convert the datas stored in the FLD1 of PF01 to the table TAB01 which is having a field FLD2 with attribute of char 10 not null with default.
-------------------------------------------------
PF's Desired o/p of o/p of
DATA Output using using
(5P 0) CHAR 7 DIGITS CHAR
-------------------------------------------------
-100.00 -100.00 10000 -100.00
100.00 100.00 10000 100.00*
20.00 020.00 02000 20.00**
3.00 003.00 00300 3.00***
0.40 000.40 00040 .40****
0.05 000.05 00005 .50****
---------------------------------------------------
where * indicates blanks.
is there is any way simple way to get the desired output?
thanks in advance..
Comment