IC5Notice: We have upgraded developerWorks Community to the latest version of IBM Connections. For more information, read our upgrade FAQ.
Topic
  • 3 replies
  • Latest Post - ‏2004-11-10T06:48:09Z by SystemAdmin
SystemAdmin
SystemAdmin
93 Posts

Pinned topic rounding off problem

‏2004-01-23T04:15:57Z |
Hi all,

Anybody out there ever been in a scenario where datastage truncates the decimal places of the result of a multiplication?

example:
123456789012345.99
x
0.1234567

123456789012345.123456789 (desired result needed for other computations)

however result is being truncated to 15 digits

TIA.
Updated on 2004-11-10T06:48:09Z at 2004-11-10T06:48:09Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    93 Posts

    Re: rounding off problem

    ‏2004-01-23T18:24:08Z  
    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.
  • SystemAdmin
    SystemAdmin
    93 Posts

    Re: rounding off problem

    ‏2004-06-29T09:56:33Z  
    Hi SonnyE,

    In DataStage Administrator, select your project and try update in Tab Mainframe the option Support extended decimal (default is 18).
  • SystemAdmin
    SystemAdmin
    93 Posts

    Re: rounding off problem

    ‏2004-11-10T06:48:09Z  
    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.

    Perry