Page 1 of 1

integers

Posted: Wed Feb 27, 2008 5:56 am
by dsdv78
Hello,

My job source is sequential file it contain column QTY as integer datatype and len 10. QTY test data like that

101
102
-10
50
100
-10000149
-1

My doubt regarding how to remove that "-" sign in the target file.i am using transferstage in the middle of source and target


Thanks

Posted: Wed Feb 27, 2008 6:09 am
by ray.wurlod
You do NOT want to remove the "-" character.

All of those values are perfectly valid (signed) integers.

Removing the "-" characters would be a loss of information.

If you must, use an Abs() function.

Posted: Mon Mar 10, 2008 8:53 am
by mcs_giri
In transformer, function there is mathematical fuction in which there is fuction fabs it will remove the negative sign and return it as a positive value