Oppolzer - Informatik / Blog

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

Thank you

Bernd Oppolzer


Am 24.02.2015 um 21:33 schrieb A.F.:
>
> The easiest way to convert a DB2 table to CSV format is to skip the middle man.
>
> Use EXCEL database services, load it up into a spread sheet, then save.
>
>
>
> Other wise, adding a middle man is a good option
>
> Unload produces 2 output files,  The data unload of course and the load utility
> control cards than map the unload file.
> With the mapping data it is somewhat easy to load the data into an excel type spreasheet.
>
> IS there any DB2 on other platforms?  The DB2 cross loader I think will create CSV files.
>
>
>
> There are a couple of important questions.
>
>     Is the original poster on IBM-MAIN a crook?  I am serious, is this an attept to export
>     data that the original requestor is not entitled too (a very common issue, unfortuneity)
>     Are there any special data items like floating point numbers, packed numbers, LOBS,
>     BLOBS, Long VARCARS?  Each of these have special considerations.
>
> A.F.