read_delimited()-invalid quotes

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
gateleys
Premium Member
Premium Member
Posts: 992
Joined: Mon Aug 08, 2005 5:08 pm
Location: USA

read_delimited()-invalid quotes

Post by gateleys »

I am reading from a Seq File into an Aggregator. I am using pipe as a delimiter and " is the quote. The source is SQL server. I have tried all the functions, viz. Convert, Ereplace and Trim. But the problem persists. I keep getting this error-

SeqFile1.DSLink4: read_delimited() - invalid quotes, row 12454 column emp_id = ""
loveojha2
Participant
Posts: 362
Joined: Thu May 26, 2005 12:59 am

Post by loveojha2 »

Check the 12454th row of the file may be it is containing an additional quote character (") in the empid column or some other column.
Post Reply