Re: Rows NOT found in cursor search

+ Look Ahead fields (Ducking and running also ...) :D


Don







From: "Mark Waterbury" <mark.s.waterbury@xxxxxxxxxxxxx>
To: "RPG programming on IBM i" <rpg400-l@xxxxxxxxxxxxxxxxxx>
Date: 15/07/2020 01:23 PM
Subject: Re: Rows NOT found in cursor search
Sent by: "RPG400-L" <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx>



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