Hi All,
When I am passing the data from one sequential file to another thro' transformer ,this character is getting appended to one of colum.
I am wondering why?
thanks
Appearance of
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 108
- Joined: Wed Jul 28, 2004 7:15 am
Thanks for responses,
My Ans to Q asked :
Q: Is this happening to the last column?
Are there any transformation being performed on the column involved?
Ans: No this Happening at first column of Target Sequientail file however the source column from where it is coming is last one.
Following transformation is being performed:-
if char(10) then char(127): DSLink3.colB else 0 (using stage variable).
Q:Is there any warning when you try viewing data from source sequential file?
No and No warning also while viewing the Target Sequential file.
Q:Check whether you have a tab char in the column. Or you may have a null value in that char
Ans: I have Tab char and Not nullable in the all the columns of all the files.
Q:It looks like you might have specified Windows-type termination when writing and then you are reading it with Unix-type termination.
Ans: Both the places are Unix-type termination.
Hope this shall help in dignosis.
Thanks
Prahsant
My Ans to Q asked :
Q: Is this happening to the last column?
Are there any transformation being performed on the column involved?
Ans: No this Happening at first column of Target Sequientail file however the source column from where it is coming is last one.
Following transformation is being performed:-
if char(10) then char(127): DSLink3.colB else 0 (using stage variable).
Q:Is there any warning when you try viewing data from source sequential file?
No and No warning also while viewing the Target Sequential file.
Q:Check whether you have a tab char in the column. Or you may have a null value in that char
Ans: I have Tab char and Not nullable in the all the columns of all the files.
Q:It looks like you might have specified Windows-type termination when writing and then you are reading it with Unix-type termination.
Ans: Both the places are Unix-type termination.
Hope this shall help in dignosis.
Thanks
Prahsant
char(127) is - you are getting what you are putting in the column.if char(10) then char(127): DSLink3.colB else 0 (using stage variable).
Is that what you meant to do?
Regards,
Precious
Mosher's Law of Software Engineering: Don't worry if it doesn't work right. If everything did, you'd be out of a job.
Mosher's Law of Software Engineering: Don't worry if it doesn't work right. If everything did, you'd be out of a job.