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 Tony's Outlook via Mozilla:
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.
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO IBM-MAIN
