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.