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
Packed decimal issue
Moderators: chulett, rschirm, roy
Packed decimal issue
pandeeswaran
-
- Participant
- Posts: 71
- Joined: Mon Jul 09, 2007 1:12 pm
When you are dealing with Packed Decimals, unload the file as complete one column (maximum length of the row) in first step. Don't do anything in this step. Just unload the file on your UNIX server. You can either unload via ftp script or use ftp plugin, use 'BINARY' as transfer mode.
Once you unload the file, use the file layout of the actual file using Complex flat file stage to read individual columns. That will give you all correct values.
Once you unload the file, use the file layout of the actual file using Complex flat file stage to read individual columns. That will give you all correct values.
From some of the experiments,i realize that, in the source sequential file stage, if we read the zoned/decimal with required properties, it's working fine.
But if we read as varchar and then we can't read it in intermediate stages.
In that case, we need to go with our own transformations.
But if we read as varchar and then we can't read it in intermediate stages.
In that case, we need to go with our own transformations.
pandeeswaran