Page 1 of 1

how to update from perticular record in db2 table

PostPosted: Fri Apr 29, 2011 10:29 am
by ashokteja
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 ......

Re: how to update from perticular record in db2 table

PostPosted: Fri Apr 29, 2011 3:25 pm
by NicC
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.