Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004
    Posts
    13

    Unanswered: Short Cut for EXPORT Statement

    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

  2. #2
    Join Date
    Aug 2004
    Posts
    24
    you can try

    db2move source_dbname export

    db2move target_dbname import

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •