Search found 2 matches
- Fri Jul 02, 2004 6:08 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Abs function is not working correctly
- Replies: 2
- Views: 1238
What is the definition (SQL type, length and scale) of input and output columns ? If output column is declared Numeric without scale specification, then Abs(-12.56) returns 13.00 If proper scale specified, then Abs(-12.56) returns correct value. Output Column has been delcared as Numeric with lengt...
- Thu Jul 01, 2004 3:04 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Abs function is not working correctly
- Replies: 2
- Views: 1238
Abs function is not working correctly
Abs function is not working correctly.
For ex:
Abs(-12.56) returns 13.00.
For ex:
Abs(-12.56) returns 13.00.