? SET ISOLATION

Dears USER'S INFORMIX: We need to lock rows of a table to show by screen through a INPUT ARRAY. For this, we accomplish the following steps: - SET ISOLATION TO REPEATABLE READ - BEGIN WORK - DECLARE c_consulta CURSOR FOR UPDATE - The recovered rows are loaded to an ARRAY - Through a INPUT ARRAY permits the modification of the recovered rows - When the user leaves from the screen is ended the transaction. The locks level of the table used in the CURSOR is to ROW. From different processes is NOT possible to agree to rows NOT selected by the CURSOR FOR UPDATE. The messages error of informix is the following: - 246 could not I give an indexed read to get next row. Please, us interesting to know if the explained procedure is incomplete or exists some another alternative that we have not considered. THANKS in advance