Truncate only record exists
Posted: Sun Jul 04, 2010 3:41 pm
Hi,
I want to truncate the target table only when the record comes from source system. My source table is in oracle database and target database is in DB2. The requirement is to move the record from source to target if record exists in the source tables, if no record exists in the source then we need to the use existing data in the tables.
Any suggestion how to implement this logic without using routine.
Thanks,
I want to truncate the target table only when the record comes from source system. My source table is in oracle database and target database is in DB2. The requirement is to move the record from source to target if record exists in the source tables, if no record exists in the source then we need to the use existing data in the tables.
Any suggestion how to implement this logic without using routine.
Thanks,