Sever Job: Not able to read (') in data
Posted: Tue Nov 18, 2008 3:56 am
Hi,
I have a server job
Seq file read -> transformer-> o/p seq file.
Data contains ... "HE GARDENER'S COTTAGE"
Server job aborts saying
STG_INP_01.INP_01: nls_read_delimited() - invalid quotes, column ADDRESS2 = "HE GARDENER'S COTTAGE","
Is this to be specially handelled?
Thanks
I have a server job
Seq file read -> transformer-> o/p seq file.
Data contains ... "HE GARDENER'S COTTAGE"
Server job aborts saying
STG_INP_01.INP_01: nls_read_delimited() - invalid quotes, column ADDRESS2 = "HE GARDENER'S COTTAGE","
Is this to be specially handelled?
Thanks