Search found 3 matches
- Fri Oct 26, 2012 6:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how to remove leading zeros for decimal values
- Replies: 5
- Views: 5850
Re: how to remove leading zeros for decimal values
For the posted example: value 0000001.00000009 If we want the output as 1.00000009 the solution is given below with the logic; USE THE LOCIG AS BELOW: (By using String function DecimalToString we can get the solution) Field(DecimalToString(InputLink.xyz,"suppress_zero"),".",1):&q...
- Mon Sep 03, 2012 2:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: generating seq nos
- Replies: 10
- Views: 6316
- Mon Sep 03, 2012 1:51 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Surrogate key using only one instance.
- Replies: 4
- Views: 4302