Dependency of unique indexes
A programmer can take advantage of the fact that DB2 returns only one row from a table with a unique index, if the full key is supplied in the SELECT statement. A cursor is not needed in this case.
If the index is changed and the uniqueness is dropped, the program does not execute correctly when two or more rows are returned. The program receives an SQL error code.