Issue while handling Decimal Fields in CFF Stage
Posted: Thu Jun 02, 2011 7:37 pm
Hi All,
I have a CFF stage as Target for my DataStage Parallel Job.
We create this file, transmit it to MF system to do a comparison.
However, when the files are NDM'd to the Source MF system, the '.' symbol of the decimal values are getting truncated due to which the comparison fails.
For e.g: a decimal field 100.01 when it goes to MF system changes to 10001.
We are using Generic UNIX script to NDM the files from UNIX system to MF system.
Any help will be appreciated.
Thanks,
Freddie
I have a CFF stage as Target for my DataStage Parallel Job.
We create this file, transmit it to MF system to do a comparison.
However, when the files are NDM'd to the Source MF system, the '.' symbol of the decimal values are getting truncated due to which the comparison fails.
For e.g: a decimal field 100.01 when it goes to MF system changes to 10001.
We are using Generic UNIX script to NDM the files from UNIX system to MF system.
Any help will be appreciated.
Thanks,
Freddie