|
|
| Author |
Message |
bh
New User
Joined: 19 Mar 2006
Posts: 26
Location: India
|
|
|
|
Hi,
Suppose i am reading from a table and updating some other table or a file ;There are 1000 records in the table from where i am reading , due to some reason i stop reading at 750th record and these are the records which i have updated in other table or a file . Now, in future i want to carry on the same process from the 751st record , so how will i achieve it ?
Two questions here--
1. I am not sure at what record i took a break.
2. I am aware at what point i took the break .
Regards,
Bh |
|
| Back to top |
|
 |
References
|
 Posted: Wed Jun 06, 2007 2:58 pm Post subject: Re: Reading a table and updating other table |
|
|
|
|
bh
New User
Joined: 19 Mar 2006
Posts: 26
Location: India
|
|
|
|
[quote="bh"]Hi,
Suppose i am reading from a table and updating some other table or a file ;There are 1000 records in the table from where i am reading , due to some reason i stop reading at 750th record and these are the records which i have updated in other table or a file . Now, in future i want to carry on the same process from the 751st record , so how will i achieve it ?
Two questions here--
1. I am not sure at what record i took a break.
2. I am aware at what point i took the break .
Regards,
bh |
|
| Back to top |
|
|
William Thompson
Global Moderator
Joined: 18 Nov 2006
Posts: 2971
Location: Tucson AZ
|
|
|
|
| bh wrote: |
1. I am not sure at what record i took a break.
2. I am aware at what point i took the break . |
If you do not keep track of where you are when you "stop reading", who do you expect will?
If the read/update cycle is identifiable enough, you might be able to spot the last updated record and us that to start reading correctly.
I'd guess that you want to implement a fairly standard checkpoint/restart logic. |
|
| Back to top |
|
|
|
|
