Hi

I am Migrating a database from v7 to v 8.1. I am using the DB2LOOK command to get the DDL statements and EXPORT command to get the data of the tables. I am using the following command to extract the data.

EXPORT TO <filename.csv> OF DEL MODIFIED BY COLDEL SELECT * FROM <tablename>

Now my problem is that I have about 2000 tables in my database and its nearly impossible for me to write export statements for the same. Is there any ways I can do it automatically so that I could get the output in a file which I can run directly. I mean to get rid of writing individual lines.

Thanks in advance.
sw_flintstone

you can try

db2move source_dbname export

db2move target_dbname import