I am selecting a column that is varchar(255) in an oracle table and writing that to a sequential file. I have left the default setting as it is in the sequential page of the stage.
I am using unix like records and hence selected unix in the option buttons given
I am finding a Quote added to the column value in the sequential file ie "xxxxx" instead of xxxxx. Since i am using this value in the down stream processing i am facing a lot of string mismatch issues while i try to compare this with some literals.
But when i view through the datastage data viewer in the sequential file stage ,there seems to be no quotes
![Rolling Eyes :roll:](./images/smilies/icon_rolleyes.gif)
![Idea :idea:](./images/smilies/icon_idea.gif)