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 unload data from table with lob columns farhad_evan DB2 0 Sat Apr 22, 2017 1:32 pm
No new posts Need help in reading and validating a... ABINAYATHULASI COBOL Programming 8 Tue Apr 18, 2017 11:42 am
No new posts Data replication from multiple Db2 ta... kishpra DB2 9 Mon Mar 27, 2017 9:58 pm
No new posts Problem reading GTF trace output danik56 ABENDS & Debugging 7 Thu Mar 16, 2017 1:02 pm
No new posts Updating a VSAM file with DISP=OLD sheersh JCL & VSAM 8 Tue Mar 14, 2017 6:14 pm


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