Insert from table in DB A to table in DB B

[Rocketfuel]

Hi

I know this is a stupid question but I am quite new to DB2. I need to copy data from a table in Database A to a table in Database B, the table in DB B already contains data I just want add to it. Can anyone help me with a query on how to achieve this I dont want to use the "Load Utility".

Thanks very much.

[docdiesel]

Hi,

there's no way to move data directly from DB A to DB B in DB2. You'll have to export the data from A and load or import it into B. Maybe you'd like to use a pipe/fifo if your DB2 is at home on Linux/Unix. That way you won't have to write and read an IXF file to disk.

Regards,

Bernd

----

mkfifo /path/to/myfifo
 
db2 connect to A
db2 export to /path/to/myfifo of IXF select * from ...
 
and meanwhile on another shell:
 
db2 connect to B
db2 load (or import) from /path/to/myfifo of IXF insert into ...
 

[Rocketfuel]

Hi,

there's no way to move data directly from DB A to DB B in DB2. You'll have to export the data from A and load or import it into B. Maybe you'd like to use a pipe/fifo if your DB2 is at home on Linux/Unix. That way you won't have to write and read an IXF file to disk.

Regards,

Bernd

----

mkfifo /path/to/myfifo
 
db2 connect to A
db2 export to /path/to/myfifo of IXF select * from ...
 
and meanwhile on another shell:
 
db2 connect to B
db2 load (or import) from /path/to/myfifo of IXF insert into ...
 

Hi

Thanks for the reply. I will definitely try your advice. I got around the problem by using MS Access and just creating a ODBC links to both databases and then executing an append query. Thanks for expanding my knowledge of DB2.

[docdiesel]

I got around the problem by using MS Access and just creating a ODBC links to both databases and then executing an append query.

Nice idea - why didn't that come to my mind? Causes a bit of network traffic if DB A, DB B and Access DB aren't all on the same (Windows) machine, but nevertheless quiet smart.

Thanks for expanding my knowledge of DB2.

Oh, the pleasure was all mine.

Regards,

Bernd