fixed file format is broken
Posted: Mon Jun 02, 2014 9:56 am
Hi,
I have a job with source as sequential file (file format is fixed width) and after transformation i need to add one more column to this file at the end but file format need to be same as it is in source,but it seems datastage is adding some sapce somewhere in file.So i am trying to do below testing.
1. Defined column definition as char in source.
for ex :- Col1 char(2)
Col2 Char(10)
In transformer i am doing one to one mapping and passing these columns to target sequential file.
When i checked length of file it is showing 13 charcter,i have no idea how one character is added to the end of every line
I will appriciate your input.
I have a job with source as sequential file (file format is fixed width) and after transformation i need to add one more column to this file at the end but file format need to be same as it is in source,but it seems datastage is adding some sapce somewhere in file.So i am trying to do below testing.
1. Defined column definition as char in source.
for ex :- Col1 char(2)
Col2 Char(10)
In transformer i am doing one to one mapping and passing these columns to target sequential file.
When i checked length of file it is showing 13 charcter,i have no idea how one character is added to the end of every line
![Embarassed :oops:](./images/smilies/icon_redface.gif)
I will appriciate your input.