×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
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
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
