Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups 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 SQL query to run through list of valu... Ni3-db2 DB2 14 Wed Dec 14, 2016 9:52 am
No new posts Updating the counters after eliminati... PANDU1 DFSORT/ICETOOL 12 Mon Nov 21, 2016 9:47 am
No new posts Updating Cursor row withour using FOR... chandan.inst DB2 15 Tue Nov 08, 2016 11:17 am
No new posts Reading data from PS file and send it... rajatbagga All Other Mainframe Topics 18 Fri Sep 23, 2016 12:51 pm
No new posts Need Rexx Program to Load in to DB2 T... Hareesh Verma CLIST & REXX 22 Tue Sep 20, 2016 2:59 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us