In this blog post, let’s learn about the error message “268 Unique constraint violated.” in Hydra and the description of the error.
Error Message
268 Unique constraint violated.
Error Details
The current statement uses the WHERE CURRENT OF cursor-name clause, but that cursor has not yet been associated with a current row. Either no FETCH statement has been executed since it was opened, or the most recent fetch resulted in an error so that no row was returned. Revise the logic of the program so that it always successfully fetches a row before it executes this statement.
Informix requires that you place for update cursors inside a transaction. Try placing BEGIN WORK and END WORK around cursor.