MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » May 2014

Re: can this reject bad data?



fixed

So on that basis Dieter you think that:

Test(DE) *YMD fieldName;

If %Error;
// Set bad date indication;
EndIf;

Is harder to understand than that awful mess of SQL that we saw earlier? Sorry can't agree.

I've got nothing against SQL but I do dislike the "The answer is SQL - now what was the question?" approach.


On 2014-05-08, 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!
UDF? fast? Materializing the results will beat the UDF and save hours of runtime, If it is needed often, for large tables! --
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.


Jon Paris

www.partner400.com
www.SystemiDeveloper.com









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

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot 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 here. If you have questions about this, please contact