-
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.
-
some possible solution ?!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|