Anybody out there ever been in a scenario where datastage truncates the decimal places of the result of a multiplication?
123456789012345.123456789 (desired result needed for other computations)
however result is being truncated to 15 digits
This topic has been locked.
3 replies Latest Post - 2004-11-10T06:48:09Z by SystemAdmin
Pinned topic rounding off problem
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2004-11-10T06:48:09Z at 2004-11-10T06:48:09Z by SystemAdmin
Re: rounding off problem2004-01-23T18:24:08Z in response to SystemAdminThis is a behaviour seen in server jobs and BASIC code (such as job sequences, job control routines). The default precision is 15 in those, though it can be configured as high as 57.
In mainframe jobs, however, (you u:7980f2f4cedid[/u:7980f2f4ce] post on the DataStage EE MVS forum) there's nothing that would limit precision. Inspect the COBOL code that is generated, to try to determine if there's anything in it that might cause what you're seeing.
Re: rounding off problem2004-11-10T06:48:09Z in response to SystemAdminIn addition to the extended decimal capability noted in this thread already, we have just added ROUND syntax to the expression editor in DS MVS Edition that enables you to tell the tool how to round the expression. This is currenty available as a patch on top of DS 7.5A and will be included in the DS 7.5.1 (Eagle) release.
Please contact Ascential Support to request the patch if you can use this capability.