the files are in the following format.

bhav_data.dbf

symbol series open delqty date
acc EQ 100.1 1/1/2004
BBB EQ 767 1/1/2004
jhj eq 656 1/1/2004
...
...
..(may be around 800 enteries per day)

acc eq 177 1/2/2004
BBB EQ 723 1/2/2004
jhj eq 64 1/2/2004
...
...
... and so on....

about 200000 records.



del.dbf

symbol series tottrdqty delqty date
acc EQ 34324 4343 1/1/2004
BBB EQ 45354 433 1/1/2004
jhj eq 4534534 56545 1/1/2004
...
...
..(may be around 800 enteries per day)

acc eq 3232177 233 1/2/2004
BBB EQ 43343 3233 1/2/2004
jhj eq 3434 5454 1/2/2004
...
...
... and so on....

about 200000 records.

I want to update bhav_data.delqty set delqty = del.delqty where bhav_data.symbol = del.symbol and
bhav_data.series = del.series and bhav_data.date = del.date

how to write a update ?
is Update-Sql faster or xbase statements ?

how to do this ?

thanx
suhashegde