Insert/Delete in DB2 table

[sainath]

Hi
I have a job design

Code: Select all

Seqfile----xfm---------db2

I have 2 sepetate jobs .One for insert into DB2 table and another for delete into DB2 table.
I want to delete or insert DB2 table based on Key feild in Seqfile.

I want to know whether i have to use target table as lookup and match on key feild and do insert or delete.

please share your thoughts
thks
sai

[DSguru2B]

If you want to delete only the records based on key field and insert new ones then you can choose update action "Replace existing rows completely" or do a simple update based on the key.

[ray.wurlod]

Otherwise two output links from the Transformer stage, each into the DB2 stage. One link manages the deletes, the other manages the inserts.