Reading Sequential File
Posted: Fri Aug 21, 2009 8:06 am
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
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