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 Searching a table for the field name? socker_dad COBOL Programming 8 Sat Mar 31, 2018 2:57 am
No new posts Need inputs on DB2 tablespace/table r... ashek15 DB2 3 Sat Mar 24, 2018 11:49 pm
No new posts COBOL declaration for table Poha Eater DB2 3 Mon Feb 26, 2018 6:58 pm
No new posts load and delete table through JCL wit... ram_vizag JCL & VSAM 9 Thu Feb 01, 2018 12:47 am
No new posts Unloading DB2 table in CSV format alo... grvtomar COBOL Programming 7 Sun Jan 28, 2018 2:05 am

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