INSERT INTO A_TABLE
SELECT * FROM B_TABLE
WHERE .....



-----Original Message-----
From: John vd Waeter [mailto:john@...]
Sent: 06 December 2006 11:27
To: IBObjects@yahoogroups.com
Subject: [IBO] Copy entire records without specifying the fields?
IB_Datapump?



Hi Group,

I want to copy records from tables in database A to tables in database
B. Both databases have the same structure. Records in source_table do
not exist in destination_table.

Is there a way to read a record from A.table and subsequently insert it
in the corresponding B.table regardless of the recordstructure (which is

the same in both tables) ?

I have about 30 tables to process this way and somehow I think I
shouldn't write 30 different SELECT and corresponding INSERT statements
specifying all fields etc.

Can/should I use IB_Datapump?

tia!

John