FTP : Unbalanced or unescaped quote character

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
iwin
Premium Member
Premium Member
Posts: 99
Joined: Mon Apr 11, 2005 9:20 pm

FTP : Unbalanced or unescaped quote character

Post by iwin »

Hi,
I am trying to FTP a file to local directory file using FTP stage and then Sequential file Stage. After running the job i am getting the following error :

"FFL..Transformer_9: Unbalanced or unescaped quote character
At row 4871".

In this record's(4871) column i found " abcd&bcd" as data.

I think it is considering "&" as Unbalancedor unescaped quote character.

Please help me how to solve this.

Thanks in advance.
khanparwaz
Participant
Posts: 60
Joined: Tue Jul 12, 2005 3:34 am

Re: FTP : Unbalanced or unescaped quote character

Post by khanparwaz »

try removing quote character by specifying 000 in seq file format at quote char txt box.
coz i tried same data but its working for me?
can u also tell us tht wats the delimiter of file?
Post Reply