Mass Updation of Records

satyajit911

Hello,

I have to mass update 40000 records using SQL. But, this operation locks the table for some while. Can anyone suggest how I can update these records part by part say 500 records at a time.

Thanks,
Satya.

docdiesel

Hi,

programming a loop externally, each time you could sort the resultset and add a "fetch first 500 rows" after your conditions. But you have to make sure that those 500 won't be on top of the list the next time.

More information about your tables and sql statements could help us to help you.

Regards

Doc Diesel

Mass Updation of Records

re: Mass Updation of Records

Similar DB2 Database bytes

/bytes/development

/bytes/it

/bytes/about