Hi all,
I am facing the problem in extracting the data from the flat file as it is my source i am getting warnings for few columns the warning says as below:
[b]read_delimited() - invalid quotes, row 8098 column LocationNameLong = "JEAN NUZZI INTERMEDIATE SCHOOL
"
I have tried using oconv and trimf and trimb functions still i am getting the same warnings.
What could be the problem i do not understand please give some valuable suggestions.
Thanks[/b]
Extracting from sequential file
Moderators: chulett, rschirm, roy
Re: Extracting from sequential file
What is the data type of this coloumn,length and all the setting on the sequential file stage.
also what is the value as you see in the data file which is giving the error.
also what is the value as you see in the data file which is giving the error.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You seem to have a leading quote character and no trailing quote character.
Or two leading quote characters but only one trailing quote character.
In short, your data contain an extraneous quote character.
The only way you can handle this in DataStage is to read the data without quote characters (specify 000) and remove them in a Transformer stage.
Better would be to require that "they" supply data without this problem.
Or two leading quote characters but only one trailing quote character.
In short, your data contain an extraneous quote character.
The only way you can handle this in DataStage is to read the data without quote characters (specify 000) and remove them in a Transformer stage.
Better would be to require that "they" supply data without this problem.
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.