Sever Job: Not able to read (') in data

harshada · Post by **harshada** » Wed Nov 19, 2008 1:25 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","

the 'S in the data is a problem. If I remove this it reads the data

Is this to be specially handelled?

Thanks

Romy · Post by **Romy** » Wed Nov 19, 2008 2:13 am

Check the delimiter that you have given in the Sequential file... Change that and try again

chandrababu.Datastage · Wed Nov 19, 2008 3:20 am

Just concatinate ur string with " ' "I think this will work..

mdtauseefhussain · Post by **mdtauseefhussain** » Wed Nov 19, 2008 5:45 am

Just try changing NLS in the file to none

ray.wurlod · Post by **ray.wurlod** » Wed Nov 19, 2008 1:14 pm

What are the format properties in the Sequential File stage - in particular the Quote Character property?

IC · Post by IC » Tue May 26, 2009 4:48 pm

[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.

chulett · Post by **chulett** » Tue May 26, 2009 4:57 pm

Similar, perhaps, but not the same. Please start your own thread so we have your particulars - version, edition, etc etc.

ray.wurlod · Post by **ray.wurlod** » Tue May 26, 2009 6:18 pm

In both cases try setting the quote character to 000.

IC · Post by IC » Wed May 27, 2009 9:50 am

[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!

chulett · Post by **chulett** » Wed May 27, 2009 9:57 am

[sigh] So much for a new thread.

The assumption is you have quotes in your quotes, is that the case?

rameshrr3 · Post by **rameshrr3** » Wed May 27, 2009 12:39 pm

This 'thread' is scalable and re-usable.And now I'm not sure who I am answering to..

Can you replace " with some other quote character that does not occur as part of the string data?Probably using a Filter Command?

DSXchange

Sever Job: Not able to read (') in data

Sever Job: Not able to read (') in data

Concatinate it