Reading Sequential File

[Shamanth_vk]

Hi,

How do we handle the below mentioned scenario in source sequential stage.

Soure file of variable length having comma delimiter and quote = single.

for ex Proper file --- >> 'a','b','c','d'

If we get a file with a record like below

for ex Invalid file --->> 'a','b,'','d'

here quote for the third field is less. But for this scenario datastage is not throwing any warning/error and reading the files successfully.

How can we handle this scenario in the source sequential stage. So that datastage will throw a warning message for this.

Thanks a lot for your valuable suggestions and guidelines.

Shamanth VK

[keshav0307]

read the file use (,') as delimiter, and quote = none.
and then trim the single quote(').

[Shamanth_vk]

Hi Keshav,

Thanks for your suggestions.

We have a scenario where in we need to abort the process if we come across any scenarios like this.