How to handle a signed numeric filed with dot and decimals?

hemanthboga · New User Joined: 15 May 2008 Posts: 1 Location: bangalore

Hi,

I need to read an amount filed x(12) field from a flat file and move it into s9(9)v99 format. My client is preparing the flat file with decimal point and sign, we dont have any other option but to receiving it into X(12) field. I had made a work aroung using redifines clause, which was working fine with +ve sign. If the amount have -Ve sign my program is abending.

For ex: if value is -90000.90 in x(12) filed, how can I move this to
S9(9)v99 field. I am having issues with handling the sign.

Thanks a lot for you help.
Heman.

Craq Giegerich · Posted: Fri Jun 20, 2008 5:56 pm

Robert Sample · Posted: Fri Jun 20, 2008 5:56 pm

COMPUTE NUMERICVARIABLE = FUNCTION NUMVAL (XVARIABLE) .

mmwife · Super Moderator Joined: 30 May 2003 Posts: 1592

Here's something to consider:

If you have 9 significant digits before the decimal point for any value occurence for the field, you will truncate the the sign. Not a prob if the sign is pos; bad if it's neg.

If your I/P fld only contains 8 integer digits you can change the O/P fld to S9(8)V99 when using NUMVAL.

Max Payne · New User Joined: 13 Dec 2007 Posts: 10 Location: Shanghai

-90000.90 in x(12)

you mean BBB-90000.90 or -90000.90BBB?

star_dhruv2000 · Posted: Tue Jun 24, 2008 1:58 pm

NUMVAL is right choice for you...

Appreciate ur effort Robert...

Cheers!

Happy coding

ssk1711 · New User Joined: 16 Jun 2008 Posts: 40 Location: bangalore