Packed decimal issue
Posted: Mon Dec 05, 2011 3:41 am
HI,
My input string contains many fields like:
1234670001234E
In this the substring input[7,8] contains decimal (overpunched).
So, in the transformer i am splitting the individual fields from the raw string.
But in this case, even though i have specified the properties in target for reading decimal, it still loads 00000.00 only.
So, can't we read the zoned/packed decimal in intermediate stages(transformers)?
In the source seq file stage, i am reading whole as varchar and i am splitting in transformer.
Please help me in this.
Thanks
My input string contains many fields like:
1234670001234E
In this the substring input[7,8] contains decimal (overpunched).
So, in the transformer i am splitting the individual fields from the raw string.
But in this case, even though i have specified the properties in target for reading decimal, it still loads 00000.00 only.
So, can't we read the zoned/packed decimal in intermediate stages(transformers)?
In the source seq file stage, i am reading whole as varchar and i am splitting in transformer.
Please help me in this.
Thanks