Oppolzer - Informatik / Blog


Blog-Hauptseite      Neuester Artikel      Älterer Artikel      Neuerer Artikel      Älterer gleiche Kategorie      Neuerer gleiche Kategorie

DB2-L - Probleme beim Entladen einer Tabelle mit Delimitern

Subject:

Unloading a table to a delimited file with non-delimited character strings

From:

Bernd Oppolzer <bernd.oppolzer@T-ONLINE.DE>

Reply-To:

DB2 List <db2-l@lists.idug.org>

Date:

2012.05.04 13:43:00


I don't understand why you need to get rid of the delimiting characters.

I call this format CSV - comma separated values, although the values
are not always separated by commas - semicolon is another option.
And IMO there is a kind of definition of CSV that states that every
CHAR column in CSV may be surrounded by char delimiters. This is needed
to make it possible that the column delimiter appears in the CHAR value.
If the char delimiter appears in the CHAR value, it is duplicated.

So every CHAR value may be surrounded by char delimiters, but there is
no need to do it, if there are no column delimiters in the value,

but:

if the sender of the CSV decides to put char delimiters around EVERY character
value, whether needed or not, this is ok and the receiver of the CSV has
to deal with this.

So DB2 is right to do it this way.

At least that's my understanding of the definition of the CSV format.

We have a home grown tool that exports and imports data to DB2 (and Oracle and MySQL)
and accepts many input and output formats, one of them is CSV.

Kind regards

Bernd



Am 04.05.2012 12:28, schrieb D.B.:
>
> P.,
>
> Thanks for your response. I appreciate you taking the time. I find it
> disappointing that I can't get rid of the characters, despite the fact
> that the IBM DB2 manual seems to indicate that I can.
>
> Thanks again.
>
> DB
>
>
> -----End Original Message-----

Blog-Hauptseite      Neuester Artikel      Älterer Artikel      Neuerer Artikel      Älterer gleiche Kategorie      Neuerer gleiche Kategorie