In case you have 1000 rows in the DB2 table, how will you update the column value of the first 100 records?

In case you have 1000 rows in the DB2 table, how will you update the c

1.	In case you have 1000 rows in the DB2 table, how will you update the column value of the first 100 records?
Answer» In case our DB2 table has an identity COLUMN, then we can use the indexnum as follows: UPDATE Table SET COLUMN_NAME=XXX where indexnum < 101