You can code a retrieve statement without an accompanying loop; in this case, one row, at most, is retrieved. This is appropriate, for instance, when your query seeks an exact match for a unique key. However, if more than one row qualifies according to the where clause, only one of the matching rows is returned.