DB2EUG: Insert Into command in DB2

Hello everyone,

Is there a DB2 SQL syntax to insert data from one database table to another database table.

I would like to avoid exporting and importing data.

This what I have in mind.

Example:

Database Names: (MEMDB1 and MEMDB2)

UserName: test

Schemas (tst and prod)

connect to MEMDB1 user test;

connect to MEMDB2 user test;

insert into MEMDB1.tst.Specialty (id_number, specialty)

select id_number, specialty from MEMDB2.prod.Specialty;

disconnect current;

Thanks in advance... I'm open to all recomendations.

Reply via email to