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.
Getting problem of extra sign byte in complex flat file
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 38
- Joined: Fri Apr 22, 2005 6:07 am
Amit, I think you can best avoid this by converting you data type to integer instead of leaving it in a decimal(0) datatype. What is your COBOL picture for this field? It is most likely a PIC S9(x) integer type - so an integer datatype from DataStage wouldn't be incorrect.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>