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
Re: rounding off problem2004-01-23T18:24:08ZThis is the accepted answer. This is the accepted answer.This 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:09ZThis is the accepted answer. This is the accepted answer.In 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.