Hello
I am updating a database with flat files. This is done every minute. The file (c:\a.dat) is parsed and updated into the database. During updating the exec_id (primary key)is generated externally uisng a sequence.
This file appears in the directory every minute. My problem is the new file in the directory contains the previous records already updated in the database. for further clarifications - the first time if C:\a.dat has 2 records after that there are 4 more records then the second time C:\a.dat would contain 6 records (2old records and 4 new records)
How do i ensure that already updated records are not taken into account and the rest is updated.
Thanks
I am updating a database with flat files. This is done every minute. The file (c:\a.dat) is parsed and updated into the database. During updating the exec_id (primary key)is generated externally uisng a sequence.
This file appears in the directory every minute. My problem is the new file in the directory contains the previous records already updated in the database. for further clarifications - the first time if C:\a.dat has 2 records after that there are 4 more records then the second time C:\a.dat would contain 6 records (2old records and 4 new records)
How do i ensure that already updated records are not taken into account and the rest is updated.
Thanks
