Unanswered: Copying a DB2 table to another server programmatically
what is the best way to copy a DB2 table to another server (DB2 too for a start) programmatically? I did some research on CLI, it is pretty easy to copy a table inside the same server, like:
insert into table2 select * from table1
but I couldn't find anything except for manually fetching record by record and inserting it to the destination table.