On Thu, May 8, 2014 at 10:05 AM, D*B <dieter.bender@xxxxxxxxxxxx> wrote:
<snip>
Especially when a few lines of RPG can do the same thing, more
readably, and probably execute faster?
</snip>

RPG? more readable? strange opinion!

Are you seriously questioning this? Did you even look at Steve's SQL solution?

UDF? fast? Materializing the results will beat the UDF and save hours of
runtime, If it is needed often, for large tables!

I'm talking about RPG wrapped in a UDF versus SQL wrapped in a UDF.

John




Return to Archive home page | Return to MIDRANGE.COM home page