Getting problem of extra sign byte in complex flat file
Posted: Mon Jan 02, 2006 2:07 am
We are using complex flat file stage in our datastage jobs. The data is coming from oracle stage then processing it and final creating complex flat file as the per the mainframe file layout. One of the field is defined as decimal but it is not having any scale that is no value after decimal. After processing we are getting additional "." in this field and because of this "." it is occuping extra sign byte in the final file.
Is there any proper datatype by which it will not take unnecessary "."?
If I change it some other datatype link is starts giving warnings.
Please let us know if anybody has got such problem and proposed solution to resolve this sign bit issue.
Thanks in Advance.
Is there any proper datatype by which it will not take unnecessary "."?
If I change it some other datatype link is starts giving warnings.
Please let us know if anybody has got such problem and proposed solution to resolve this sign bit issue.
Thanks in Advance.