How to avoid sign
275 pts.
0
Q:
How to avoid sign
hi,

i have a char field of 20 length, front end that field is alphanumeric , now suppose the data is -0.9, and i need to apply some calculations on it, when i move it into numeric feild for that ,
one dump occurs that is decimal data error.

please help me how can i do it.....

dump is----

decimal-data error at statement 175. A packed or zoned value does not
contain valid numeric data. A digit and/or sign is not valid. -----

Thaks & Regards
Ambrish Srivastava
ASKED: Nov 19 2008  6:51 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
0
275 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
instead of move use the function %DEC( charFld : width : dec )

C eval fldn = %dec(%trim(char20):10:5)


Thanks a lot.....
Last Answered: Nov 20 2008  12:54 AM GMT by Ambrish 82   275 pts.
Latest Contributors: Graybeard52   2425 pts., Philpl1jb   24570 pts.
0
0
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Ambrish 82   275 pts.  |   Nov 20 2008  12:56PM GMT

thanks a lot

 
0