Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Reading a table and updating other table

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
bh

New User


Joined: 19 Mar 2006
Posts: 26
Location: India

PostPosted: Wed Jun 06, 2007 2:58 pm    Post subject: Reading a table and updating other table
Reply with quote

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
View user's profile Send private message

bh

New User


Joined: 19 Mar 2006
Posts: 26
Location: India

PostPosted: Wed Jun 06, 2007 2:59 pm    Post subject: Re: Reading a table and updating other table
Reply with quote

[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
View user's profile Send private message
William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3158
Location: Tucson AZ

PostPosted: Wed Jun 06, 2007 3:13 pm    Post subject: Re: Reading a table and updating other table
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Update table without cursor Ron Klop DB2 3 Wed Oct 11, 2017 1:06 pm
No new posts Table(Unicode(Graphic) table) loading... muralikrishnan_new DB2 0 Thu Oct 05, 2017 5:10 pm
No new posts opening a dataset after reading it fr... arunsoods DFSORT/ICETOOL 5 Wed Oct 04, 2017 3:54 pm
No new posts Insert a Row_number into table useit DB2 2 Tue Sep 19, 2017 1:07 pm
No new posts how to see when the last read access ... Mike 1304 DB2 1 Tue Sep 12, 2017 7:52 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us