ANL7013I *** GUIDELINE: DO NOT USE ABSOLUTE CURSOR POSITIONING WHEN YOU ARE UPDATING ONLY A SINGLE ROW, UNLESS YOU HAVE SELECTED THE ROW TO GUARANTEE THAT NO CHANGES WILL OCCUR BETWEEN THE SELECT AND UPDATE. ELSE, IT IS MORE TIME CONSUMING FOR Db2® TO POSITION THE CURSOR RATHER THAN TO DO A DIRECT UPDATE ON THE ROW. ALSO, CONSIDER KEEP UPDATE LOCKS AS A MEANS OF SERIALIZING UPDATES AND COMPLETING THEM QUICKLY.
User response
As appropriate.