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
Search found 3 matches
- 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: 928
- 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: 928
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...
- 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: 928
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...