Extracting from sequential file

[rajeevm]

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]

[sun786]

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.

[ray.wurlod]

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.