Search found 3 matches

by KishoreRaju
Thu Mar 15, 2007 12:43 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: discarding sign byte for a decimal when writing it to a file
Replies: 5
Views: 930

in the requirments i have a separate field for sign .for that reason i am removing the sign when writing the decimal value.


is there any other way that i can do ,with out doing all these conversions
by KishoreRaju
Thu Mar 15, 2007 12:05 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: discarding sign byte for a decimal when writing it to a file
Replies: 5
Views: 930

Thanks for the quick reply. The complete description about my senario. input-OralceStage-->Transformer--SequentialStage(Flat file fixed width) i have data stage job which is retrieving a decimal of size (15,2) and in the target i have to map it to (5,2). in the transformer i created two stage variab...
by KishoreRaju
Thu Mar 15, 2007 11:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: discarding sign byte for a decimal when writing it to a file
Replies: 5
Views: 930

discarding sign byte for a decimal when writing it to a file

Hi I am new to data stage. when i am writing decimal onto a file its giving an extra space for the sign . it is possilbe to write without sign space.can any one tell how can we do this . i tried below ways. using Abs ,DecimalToDecimal functions configuring the properties in the sequential file stage...