I have a source sequential file with three fields and a target table with no primary key/s.
I need to delete those records where there is match in the table for those three fields.
I used a custom SQL as follows
delete from tbl_sample where A=? and B = ? and C = ? ;
but this does not seem to work...
any ideas as to how i could get this to work ?
Thanks
Unable to delete matching record from table with no primary
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You need to mark columns A, B and C as Key in your job design. "Key" in this context does not mean primary key - it means "search key" and gets the parameter markers to bind to the WHERE clause.
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.