Hi,
File ---------trans---------oracle table
If the value read from the file is present in the oracle table for the perticular column , then delete all records from table with the same column value.
Input File Column : A
Target Clomun : B
I have used the Write Method as Delete Rows , the issue is with the query
DELETE
FROM
table_name
WHERE
B = ????
how to get the column value , it should have the value of column A
Deleting rcords from table based on incoming column value
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 15
- Joined: Tue Aug 26, 2008 5:07 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Deliver the value of A on the link as a column called B and marked as Key.
Code: Select all
DELETE FROM table_name WHERE B = :1
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.