In case my DB2 table has an identity column, then we can use the indexnum as follows:  Update Table SET COLUMN_NAME=XXX where indexnum < 101