integers

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
dsdv78
Participant
Posts: 17
Joined: Mon Jan 07, 2008 4:58 am
Location: chennai

integers

Post 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
DSDV
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post 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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
mcs_giri
Participant
Posts: 14
Joined: Sat Sep 22, 2007 8:44 am
Location: chennai

Post 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
GIRIDHARANJ
Post Reply