Hi ,
I need to extract the data from a sequential file and load it into a target which is also a sequential file.
The thing is source is a delimited file with first line as column names ,I can view the data in the source using "view data option" in the source stage. I want the target also in the same format as delimited and first line as column names .
But after run the job I got the target with data with final delimeter even I skip that property in the format tab what should I do to get the data without fina delimiter.
working with sequential file
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Set the Final Delimiter property value to None.
If you have only one link in the job, you will need to put some innocuous stage (such as a Copy stage) between the two Sequential File stages.
If you have only one link in the job, you will need to put some innocuous stage (such as a Copy stage) between the two Sequential File stages.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Hi ray,ray.wurlod wrote:Set the Final Delimiter property value to None.
If you have only one link in the job, you will need to put some innocuous stage (such as a Copy stage) between the two Sequential File stages. ...
I tried by putting none for the final delimeter option even I am getting the output with delimeter
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Prove your design. How many columns in the record schema, and how many fields appear in your output file? What happens if you change the Final Delimiter character (just for the test) to something else, say ";".
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.