dump of DB2

[Marcin]

Hey,

Is there any way to dump data and database structure to file,
something like export in oracle or mysqldump in mysql.
I want to move database and all data to DB2 on Windows Server.

[Steve Landess]

Post by Marcin
Is there any way to dump data and database structure to file,
something like export in oracle or mysqldump in mysql.
I want to move database and all data to DB2 on Windows Server.

Marcin -

You can retrieve the SQL DDL for for the iSeries files in a given library by
using iSeries Navigator and then use it within DB2 UDB on the Windows system
to create the tables.

IIRC, you can also create a DRDA connection to the iSeries database from DB2
UDB on Windows and then use SQL scripts/commands to transfer the data...

Steve Landess
Austin, Texas
[phone]

[frrr]

Drogi Marcin,
Yes, there is a way to dump the AS400 definitions to a file.
It is based on the QSQGNDDL api, and instead of listing its usage here, I
refer you
to http://www.itjungle.com/mgo/mgo060502-story01.html for details and for
example of usage.

To dump the data itself you will have to use the CPYTOIMPF command, that
exports
data to a delimiter separated text file.

Both utilities deal with a single table at a time.

There is no free tool that I know of that will export entire libraries in
this way.


Shalom (Slawek) Carmel
www.venera.com , AS/400 (in)security

Post by Marcin
Hey,
Is there any way to dump data and database structure to file,
something like export in oracle or mysqldump in mysql.
I want to move database and all data to DB2 on Windows Server.

[marty]

I wrote such a tool to export all tables (and maybe members) of a whole
library for myself as i needed that for a customer. It's a tricky but small
CL script,
kind of beta and might contain errors, but if anyone needs to
export a whole library to *.csv files, please contact me directly by mail.

-h

Post by frrr
To dump the data itself you will have to use the CPYTOIMPF command, that
exports
data to a delimiter separated text file.
There is no free tool that I know of that will export entire libraries in
this way.

[Holger Scherer]

Waah, sorry, should not post with my test account <g>

Please see headers for real Mailadress ;-)

-h

Post by marty
I wrote such a tool to export all tables (and maybe members) of a whole

[Holger Scherer]

Hm, now i got some requests for this program, but
please give a correct mail answer adress ;-)

-h

Post by marty
I wrote such a tool to export all tables (and maybe members) of a whole
library for myself as i needed that for a customer. It's a tricky but small
CL script,
kind of beta and might contain errors, but if anyone needs to
export a whole library to *.csv files, please contact me directly by mail.