Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2002
    Posts
    15

    Red face Unanswered: HELP! - Copy a row from one table to another

    Please HELP!

    I have a DB2 table with 10 rows in it residing in schema1. I have an identical table in schema2 with 3 rows in it.

    Through SQL (Command Center) How can I copy the three rows from schema2 into schema1?

    I know in Oracle I could perform the following:

    insert into table table_one (select * from table_two);

    Is there a similar method for DB2???

    THanks
    Shannon Whitty
    reynolds.com.au

  2. #2
    Join Date
    Nov 2002
    Posts
    15

    Re: HELP! - Copy a row from one table to another

    How about I just use the exact same syntax!!!! Sorry to bother you all ...
    Shannon Whitty
    reynolds.com.au

  3. #3
    Join Date
    Apr 2003
    Location
    Florida
    Posts
    79
    F.Y.I.
    I just used Export/Import to populate 20 million rows between two tables that are exactly the same.... (From Prodcution to data warehouse).

    The export was very slow - but with smaller tables (200,000 rows) it worked Great..... 100 times faster than Unload - FTP - lOAD.

    Rick

  4. #4
    Join Date
    Jan 2003
    Posts
    1,605
    Use load instread of import. Load is 100 times faster then import.

    Hope this helps,
    Grofaty

  5. #5
    Join Date
    Apr 2003
    Location
    Florida
    Posts
    79
    Load is much faster on larger tables - No Doubt - but for smaller tables (400,000 rows or less) it is faster for me as DWH DBA to create 5 lines of code for the Export/Import statement rather than spending several hours building Unload-FTP-Load statements.

    Just doesn't make since to do that when the Export/Import is running about 15 seconds per 200,000 rows.

Posting Permissions

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