is this code correct or do i need to put the table name befror the field name
UPDATE NRIV SET NRRANGENR = number where OBJECT = 'J_1IEXCLOC'
or it should be
UPDATE NRIV SET NRIV-NRRANGENR = number where NRIV-OBJECT = 'J_1IEXCLOC'