Delete records from a Hash file

[Shree0410]

Hi all,

I have a situation where I have to delete records based on a key.

Oracle table as the source with columns

DNO - Key
DNM
LOC

I have a Hash file with thye same column definition. I have to delete records from the Hash file based on the DNO - key, so if the Oracle table has 3 records with 10,20,30 as the DNO values and the Hash file with 4 records with 10,20,30,40 as the DNO values, I have to delete the matching 3 records from the Hash file(records 10,20 and 30)

Please help me do this.

Thanks

and I have to delete the records

[chulett]

We've talked about this recently - search the forums, all terms, for "delete hashed".