double quotes inside data

[dnat]

Hi,

I have double quotes inside the data.

While reading, i am getting this error

with 'delim=end' did not consume entire input, at offset: 317

Ex

"1"|"9999"|"Exbis"|"MC"kh""|""

I searched the forum and i couldnt find any resolution to handle this

I have the Quote character as double quote now, i changed it to none, but then all the records are getting rejected.

Any help?

[ArndW]

dnat - your source file is badly formed, the correct thing to do is to correct the file. If that is not possible then another option would work if you are certain that your column separator, the '|' symbol, does not occur in the data. In that case, don't use a quote character at all and read in the strings, then strip leading and trailing double quotes from each string. Another option is to "fix" the file. Declare it as just one (big) column, then replace all double-quotes with two double quotes where the quote is not preceded by or followed by a pipe.

[DST]

dnat

i have the same problem. in server jobs this works correct.
here is the answer from IBM support:

"Yes, Parallel job doesn't manage quote included in a field as a Server job for the reading of sequential file (CSV file).

I confirm Parallel job doesn't manage quote included in a field as a Server job for the reading of sequential file (CSV file).
To read this type of CSV file, they could:
- keep a "Server" job to read data, and include this job in a job sequence.
- write a specific 'buildop' to split the record in fields, and use this 'buildop' reading 1 record=1 field."

I am going to achieve a recognition of it as a bug

[ArndW]

DST - this is not a bug.

Code: Select all

"I am not " a well-formed sentence. But ""I"" am."

Embedded quotes must be doubled.

[DST]

ArndW

ok,
another example:

1,"company name ""super company""",company1

is well-formed or not ? and if i get it from not-covered resource. what should i do ??
this ok in server jobs, why failed in parallel ?

[ArndW]

[

Code: Select all

1,"company name ""super company""","company1"

is a WFF.

The server job is tolerant of this incorrect data format.

[DST]

[

Code: Select all

1,"company name ""super company""","company1"

is a WFF.

The server job is tolerant of this incorrect data format. ...

... but parallel job not ((( why ???

[ArndW]

The appropriate question is not why it doesn't work in PX jobs but why it works (when it shouldn't) in Server jobs.