Re: Rows NOT found in cursor search

Matching Records in RPG.   (Ducking and running ...)  :D

On Tuesday, July 14, 2020, 11:17:43 PM EDT, Javier Sanchez <javiersanchezbarquero@xxxxxxxxx> wrote:

Thanks for all of your contributions.  I was actually after an answer more
closely related to a MERGE statement in which I can have the opportunity to
query the found and NOT found event.

While the engine is searching I can assume that a cursor search is not able
to return a condition of NOT found.

Of course I built a table with the literal values and over that table I
built a cursor, which is very trivial.  But my intention was to investigate
whether the task of a cursor could give a hand in reporting a NOT found
condition.

A MERGE can do that with the WHEN MATCHED and the WHEN NOT MATCHED
condition is met for every row in interest, but it's more elaborate (not so
hard either) than a simple cursor search.

Thanks.

JS