Thanks Kryt0n, it is only you who has fully paid attention to the question itself and has answered it clearlyKryt0n wrote:Anyway, in answer to the issue, in the aggregator properties, under aggregations, select "Default To Decimal Output" and set to 39,12... or 38,10 or whatever else you want...
Search found 2 matches
- Tue Nov 01, 2011 8:32 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Implicit converison in Aggregate stage
- Replies: 8
- Views: 7992
- Mon Aug 08, 2011 9:48 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Datetime field overflow error
- Replies: 17
- Views: 14464
For Date column type I used
Code: Select all
TimestampToDate(CurrentTimestamp())