Oppolzer - Informatik / Blog


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

IBM-MAIN - DB2-Unloads im CSV-Format

Subject:

Re: Db2 table unload (CSV format)

From:

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

Reply-To:

IBM Mainframe Discussion List <IBM-MAIN@LISTSERV.UA.EDU>

Date:

2015.03.27 01:32:45


This has been discussed recently, also on IBM-Main.
Look here: https://listserv.ua.edu/cgi-bin/wa?A2=ind1502&L=ibm-main&F=&S=&P=563359

See 3rd paragraph.

In general, with CSV the values have to be quoted (at least char values),
because they may contain the separation character, and if they were not quoted,
this may lead to confusion. CSV allows that the quotes may be omitted, if there
are no separation characters inside the values (as it is the case with all
numeric values, of course), but it is OK to surround all values with quotes.
Quotes inside of (char) values have to be doubled.

Kind regards

Bernd


Am 26.03.2015 um 21:46 schrieb R.T.:
> Thanksa lot Kolusu for putting this.  Let me see how to overcome this issue .. Thanks!
>
> ----------------------------------------------------------------------
> For IBM-MAIN subscribe / signoff / archive access instructions,
> send email to listserv@listserv.ua.edu with the message: INFO IBM-MAIN
>

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to listserv@listserv.ua.edu with the message: INFO IBM-MAIN

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