Unable to delete matching record from table with no primary

[cosec]

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

[ray.wurlod]

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.

[chulett]

And why in the world use "custom" sql for something as simple as this? My rule? Only when absolutely needed, otherwise the stage generates the SQL.