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.