Results 1 to 2 of 2

Thread: Bulk Data Transfer in DB2

  1. #1
    Join Date
    Oct 2005
    Posts
    1

    Bulk Data Transfer in DB2

    Hi ,

    I have two DB2 databases source and target.

    One is our original application database and the other is

    archive database.I need to transfer data from source

    database to target database using sql queries.

    For the same problem i got the solution in sqlserver and oracle.

    In the sqlserver the solution is like this:

    insert into targetservername.databasename.owner.tablename
    select * from tablename.

    In oracle we need to create dblink.

    insert into tablename &dblinkname select * from tablename.

    I think u can get some idea by looking at the above queries.

    I need similar type of solution in db2.Please can anybody help

    me?

    Thanks in advance.

    Regadrs
    V.Venkateshwarlu.

  2. #2
    Join Date
    Oct 2005
    Posts
    1

    some possible solution ?!

    try this.... i just found this online.
    http://www-128.ibm.com/developerwork...dm-0402stolze/

Posting Permissions

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