how to update from perticular record in db2 table



how to update from perticular record in db2 table

Postby ashokteja » Fri Apr 29, 2011 10:29 am

hi all,
recently i attended one interview , in that interviewer asked me a question on db2, . i.e.
am updating 1 lac records in db2 table meanwhile i got abend at 1001 th record , every 500 records updates commit is there,
need to start the step from 1002 record ,
please anybody tell me the answer , how to restart from a perticular record in db2



Thanks advance ......
ashokteja
 
Posts: 10
Joined: Fri Dec 10, 2010 2:36 pm
Has thanked: 0 time
Been thanked: 0 time

Re: how to update from perticular record in db2 table

Postby NicC » Fri Apr 29, 2011 3:25 pm

How do YOU think? There are couple of ways so how would you do it? Someone will check your idea(s) and comment on it(them).

The DB2 section of the forum would be a good place to start your research.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times


Return to Interview Questions

 


  • Related topics
    Replies
    Views
    Last post