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.
fixed file format is broken
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
fixed file format is broken
Thanks
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
What tool are you using to check the length? UNIX type files will have a <LF> and Windows format files will have <CR><LF> at the end of each line unless explicitly turned off in sequential file stage definition.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
Hi,
I have not defined anything in record delimiterr and my source file is only having new line.
When file is created on after processing I checked the length of file in unix using command.
Awk '{print length ($0)}' output file name
And its giving 17 but source file is 15
I have not defined anything in record delimiterr and my source file is only having new line.
When file is created on after processing I checked the length of file in unix using command.
Awk '{print length ($0)}' output file name
And its giving 17 but source file is 15
Thanks
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/