Sever Job: Not able to read (') in data
Moderators: chulett, rschirm, roy
Sever Job: Not able to read (') in data
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","
the 'S in the data is a problem. If I remove this it reads the data
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","
the 'S in the data is a problem. If I remove this it reads the data
Is this to be specially handelled?
Thanks
-
- Participant
- Posts: 2
- Joined: Wed Nov 19, 2008 1:01 am
Concatinate it
Just concatinate ur string with " ' "I think this will work..
-
- Participant
- Posts: 38
- Joined: Mon Feb 27, 2006 10:34 pm
- Location: Chennai
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
[quote="ray.wurlod"]What are the format properties in the Sequential File stage - in particular the Quote Character property? ...[/quote]
Hello,
I am having a similar error:
read_delimited() - invalid quotes
My Job runs fine reading most of the files, but I get this error 2 files. The data in the file looks fine to me, no obvious reason for the error.
My version: DataStage Server 7.5.2.
It's a csv file, there are quotes around char and varchar data; hence I choose:
delimiter as , and
quote char as "
Please advise.
Thanks.
Hello,
I am having a similar error:
read_delimited() - invalid quotes
My Job runs fine reading most of the files, but I get this error 2 files. The data in the file looks fine to me, no obvious reason for the error.
My version: DataStage Server 7.5.2.
It's a csv file, there are quotes around char and varchar data; hence I choose:
delimiter as , and
quote char as "
Please advise.
Thanks.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
[quote="ray.wurlod"]In both cases try setting the quote character to 000. ...[/quote]
Hi Ray,
Well, in the actual file, there are quotes (") around char/varchar and timestamp columns, that's why I choose Quote Character as " in the Fromat tab.
Are you suggesting to change this to 000 (instead of ")?
Thanks much!
Hi Ray,
Well, in the actual file, there are quotes (") around char/varchar and timestamp columns, that's why I choose Quote Character as " in the Fromat tab.
Are you suggesting to change this to 000 (instead of ")?
Thanks much!