IBM Support

Datastage server job with sequential stage rounds off the numbers greater than 15 digits when used in Arithmetic operations

Technote (troubleshooting)


Numbers greater than 15 digits (1234567890123456) being rounded off after 15th digit (1234567890123450) when used in Arithmetic operations of the server job

Diagnosing the problem

Arithmetic operations return zero after 15th digit of the numbers used in the sequential file stage of the server job

Resolving the problem

Set the user defined environment variable DSUseStringMath to the value of 1 in the Datastage Administrator client and compile the job

Document information

More support for: InfoSphere Information Server

Software version:

Operating system(s): AIX, HP-UX, Linux, Solaris

Reference #: 1609503

Modified date: 09 May 2013