Marcos,

> Hi, I need to do a data consolidation between 2 tables with same
> structures.
> What component can I use to da that ?

I recommend you add a column SYNC_ID and then write a stored procedure that
receives all the records from one table (via a PULL rather than a PUSH) and
then mark records that are the same with a new SYNC_ID, insert and update
records that need it and then any record that doesn't have the "touched"
SYNC_ID value can be deleted if need be.

You will need TIB_DSQL for the stored proc execution and TIB_Cursor to pull
the data from the source.

Hope this helps,
Jason Wharton