Double column data Issue
Posted: Wed Jun 08, 2011 9:06 am
Hi,
We are migrating to DS 8.5 and the jobs which are working fine in 7.1 are failing in 8.5 because the column which are defined as double are getting trailing zeros.
Whenever we change the column type to decimal...the problem get fixed and then in the same job the problem comes again with another column which is defined as double.
Can somebody provide me help where in we need to put a environment variable or a fix that can fix this issue as we have multiple jobs in different project and it is hard to change all the column from double to decimal
We are moving server job to 8.5
Let me know if you need more information on this.
We are migrating to DS 8.5 and the jobs which are working fine in 7.1 are failing in 8.5 because the column which are defined as double are getting trailing zeros.
Whenever we change the column type to decimal...the problem get fixed and then in the same job the problem comes again with another column which is defined as double.
Can somebody provide me help where in we need to put a environment variable or a fix that can fix this issue as we have multiple jobs in different project and it is hard to change all the column from double to decimal
We are moving server job to 8.5
Let me know if you need more information on this.