Oppolzer - Informatik / Blog


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

IBM-MAIN - DB2-Tabellen entladen im CSV-Format

Subject:

Re: Unload DB2 table in CSV format

From:

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

Reply-To:

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

Date:

2015.02.26 00:51:00


I posted it on the DB2 list some days ago, and if you don't mind, I post it
here, too, because it's the same topic.

<ad>
I am selling a product running with DB2 and Oracle DBs, that generates CSV files
from SQL results. It runs on almost every platform (mainframe, Unix, Windows).
CSV is one of many output formats; others are flat files, XML, and other
proprietary formats, which contain not only data, but meta data (like
datatypes), too.

It is possible to work the other way, too, that is, load DB2 data from CSV files
(and the other formats, too, of course). You can trigger insert statements from
the data in the CSV files, or updates, or deletes ... any kind of SQL statement
that modifies the DB. (You specify the SQL, together with a file description, is
necessary, that is: if the file does not already contain the needed meta data).

In combination, it is very easy to do database migrations and database schema
changes using this tool. I've done this many times for different customers.

Please feel free to contact me offline, if you are interested.
</ad>

The mainframe variant of this product is z/OS batch, and it runs very fast. No
need to inserts tabs or commas in a second step ...

Thank you

Bernd Oppolzer



Am 26.02.2015 um 00:42 schrieb T.:
> I'd certainly prefer zOS/batch/DFSORT.  Unload the table to FB disk,
use DF/SORT to insert x'05'(tab) or comma(CSV) where desired.
I do this quite often to create a flat file that will eventually go back
to MS excel/access.  Millions of records? No big deal.

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