Getting problem of extra sign byte in complex flat file

Amit Jaiswal · Post by **Amit Jaiswal** » 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.

ArndW · Post by **ArndW** » Mon Jan 02, 2006 4:17 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.