Hi ,
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 Any suggestions on what shall be done
Quotes added in writing to a sequential file
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 247
- Joined: Mon Jan 22, 2007 11:33 pm
Quotes added in writing to a sequential file
Regards
Ragu
Ragu
Nothing is wrong. Quotes are normal for string data in sequential file data and should not be causing problems in your 'downstream' processing. The data viewer doesn't show them to you because they are delimiters, not part of the data.
If for some reason you really don't want them in the file, change the Quote Character in the Sequential File stage from " to 000.
If for some reason you really don't want them in the file, change the Quote Character in the Sequential File stage from " to 000.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 78
- Joined: Fri Mar 02, 2007 4:54 am
- Location: CHENNAI
-
- Participant
- Posts: 247
- Joined: Mon Jan 22, 2007 11:33 pm
-
- Participant
- Posts: 247
- Joined: Mon Jan 22, 2007 11:33 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Technically it means to use the ASCII NUL character (0x00) as the quote character. This is effectively using a zero-length string ("") as the quote character.
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.